Data explorer (DuckDB)
The /data-explorer route loads tenant analytics exports into DuckDB-WASM in the browser. It gets the manifest from GET /analytics/export, downloads ready or stale Parquet files, and queries loaded tables locally. Refresh Data calls POST /analytics/export/refresh and reloads the export.
When a selected table is unavailable locally, Run Query falls back to GET /analytics/trends for net-revenue trend data. That fallback does not execute the arbitrary selected source query.
The page contains a fixed seven-source presentation catalog and built-in SQL templates. Template minimum tiers are Core, Growth, and Scale, but the current page hard-codes growth instead of loading billing entitlements. Treat displayed template access and row counts as provisional.
Date, column, grouping, and sort controls feed query construction. The visible Filters and Save View controls have no implemented persistence workflow.