โ† Snowflake questions
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.