Place a saved query result into a sheet and keep it fresh. A 1:04 full-HD video recorded on the real ATX AnalyticsTable application, part of the sql, duckdb and saved queries tutorials.
Saved queries live as .sql files in the project's queries folder, so they are versioned with the project. Pinned into a sheet, a query can be refreshed by the scheduler instead of by hand.
The clip pins revenue-by-month and adds every grid binding to an hourly refresh.
Get Data → Empty Grid → SQL → Queries → revenue-by-month → Edit → Run → Sheet → Get Data → Static → Insert Table → SQL → Refresh Scheduler → Add
This site needs JavaScript for the full experience. Every page above is reachable without it.