Query raw data in SQL Explorer
Query the event tables directly with SQL.
You can write SQL queries directly against your event tables to slice, aggregate, and analyze data the UI doesn't expose. This is useful when you need custom metrics, bulk operations, or a deeper look at patterns in your booking history.
SQL Explorer gives you the full power of your data without leaving the product.
Open SQL Explorer in the sidebar.
SQL Explorer opens with a blank query editor ready for you to write against your event schema.
Enter the Query against the events table; schema autocomplete assists as you type.
As you type, autocomplete suggests table names, columns, and functions so you don't need to memorize the schema.
Click Run query; results stream in and heavy queries are sampled for a fast preview.
Heavy queries are sampled first to give you a fast preview, then the full result set loads in the background.
Chart the results, export them as CSV, or save them as a scheduled dashboard tile.
Save results as a dashboard tile to re-run the same query on a schedule, keeping your metrics fresh without manual work.
What's next
Once you've built a query you want to track, save it as a dashboard tile so it updates automatically. You can also share the results with your team by exporting to CSV or embedding the chart in a report.