Cache

Execute queries against cache backends (Starburst, ClickHouse) to retrieve and analyze data.

📄️ Create Cache Connection

Set up a source to be queryable by the cache. Admin-only for now, in production this will be done by an AsyncJob.

📄️ Delete Cache Connection

Delete all cache tables associated with a source

📄️ Merge Synced Data

Merge recently synced data into the primary table, making it available for queries. Admin-only.

📄️ Get Metadata

Retrieve metadata for the cache backend (catalogs/schemas/tables for Starburst or databases/tables/columns for ClickHouse)

📄️ Query Cache

Execute a query against the cache backend (Starburst or ClickHouse)