SQL and Snowflake Architecture | Dataford Interview Questions

Describe a time you used SQL to solve a problem involving Snowflake architecture or performance considerations.

Keep your answer focused on the SQL analysis you performed, the data signals you checked, and the change you made. If helpful, mention the Snowflake features or workload patterns you evaluated.

Output

Describe the problem, the SQL-based investigation, and the outcome.
State the key tables, views, or query-history fields you relied on.
Explain any performance metric or execution pattern you used to justify the fix.

Schema

query_history

Column	Type	Description
query_idPK	VARCHAR(64)	Unique query identifier
query_type	VARCHAR(50)	Logical type of query such as SELECT or MERGE
warehouse_name	VARCHAR(100)	Snowflake warehouse used for execution
warehouse_size	VARCHAR(20)	Warehouse size at execution time
start_time	TIMESTAMP	Query start timestamp
execution_status	VARCHAR(20)	Execution outcome
total_elapsed_time_ms	INT	Total elapsed time in milliseconds
bytes_scanned	BIGINT	Bytes scanned by the query
partitions_scanned	INT	Micro-partitions scanned by the query
partitions_total	INT	Total micro-partitions available
query_tag	VARCHAR(100)	Optional workload tag

Your question is SQL and Snowflake Architecture. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem