System DesignReported in a candidate post, Feb 2024
Design a query audit log system
Filed under Snowflake
The question
Design a system that records the queries run against a data warehouse so users can find which columns and tables were accessed in a time window, and which have not been accessed for some period t. Storage is unconstrained and the system must be highly available and reliable, comparable to Postgres pg_stat.
No write-up yet. Related questions below have one.
Collected from public candidate posts and coding forums. Updated Nov 2026.