Ryft continuously collects and analyzes the query history from all engines connected to your lakehouse.This information powers Ryft’s intelligent optimization engine, allowing it to detect inefficiencies and optimize data layout based on your organization’s usage patterns.Queries are also visible in the Ryft platform, providing deep visibility into how data is accessed and used, and enabling your team to identify inefficiencies and optimize performance.Explore query activity and trends in the Query Explorer, or directly in the Queries tab of specific tables.
The Query Explorer provides visibility into every query executed across your lakehouse and query engines. It enables flexible filtering, sorting, and analysis capabilities for troubleshooting, performance tuning, and optimization.You can use the Query Explorer to:
Identify slow or expensive queries
Analyze trends in usage across users, engines and tables
The Query Explorer supports dynamic filtering and sorting on many fields, allowing you to slice and dice your query history. You can filter and sort by:
Engine (e.g. Snowflake, Trino, Spark)
Owner
Status
Query Duration
Assets Referenced (tables/views mentioned explicitly in query text)
Tables Used (resolved physical tables accessed)
Columns Referenced
Query Tags
And many more…
The Column Picker lets you customize which fields are visible in the table view. Over 50 fields are available, including engine-specific fields for the query engines that you connect.
Export - export filtered results to a CSV file. All exported values are unformatted for easier post-processing - durations in milliseconds, sizes in raw bytes, etc.
Shareable URLs - the current view can be shared with team members simply by sending the current URL. All filters, columns and sorts are encoded in the URL.
