Starts at 2:15:00 in this video — SQL Warehouse full course — caching (2:15:00)
Query history features (exam)
History is not notebook-only and not 24-hour-only. You can typically:
- Filter by user, date range, compute (warehouse), status
- Open a statement for duration and I/O / execution metrics
- Jump into the profile
It tracks SQL warehouse statements (and more depending on compute). It is the audit trail for expensive queries.
Caching
Repeated identical queries can hit a result cache. Warehouses also cache recently read Delta files. Cache is a latency feature; data changes invalidate it. It is not a security boundary.
Delta history as analysis
DESCRIBE HISTORY catalog.schema.table (and time travel) lets you audit, compare versions, and validate that yesterday’s dashboard number matches a prior version — until VACUUM removes files.