practice · query
read-only · SELECT / WITH only
Query Playground
A mini SQL console over the embedded snapshot. Pick a catalogued question, edit the SQL, and run it — no network, no credentials. Every result is labeled by source so you always know what's real: canned counts are real, individual row values are illustrative.
Catalogued queries
SQL editor
⌘/Ctrl + Enter to runRuns offline via
runQueryOffline() — no data leaves your browser.Results
Run a query to see results here. Pick a catalogued question on the left, or write your own
SELECT.Read-only playground
The issued Redshift credential is read-only — only SELECT / WITH statements are ever accepted. No INSERT / UPDATE / DELETE reaches the warehouse.
Live execution would slot into a server-side boto3 Redshift Data API proxy (asynchronous, paged, IAM-auth). Here it resolves against an embedded snapshot instead.
Probe a table
Beyond the catalogued questions, type SELECT ... FROM asd_<sport>.<table> LIMIT n. The offline runner has illustrative rows for: