Snowflake and dbt Experience | Dataford Interview Questions

Questions about Snowflake and dbt.

Write a PostgreSQL-compatible query against dbt-style model and run metadata. Return the latest run for every active model, or indicate that the model has never run. If the latest run has no failed-test count, report zero.

Output

One row per active model with model_name, materialization, latest_status, latest_started_at, and failed_tests
Include active models without a run
Sort by model_name ascending

Schema

dbt_models

Column	Type	Description
model_idPK	INT	Unique dbt model identifier
model_name	VARCHAR(150)	dbt model name
materialization	VARCHAR(30)	dbt materialization type
is_active	BOOLEAN	Whether the model is currently active

dbt_model_runs

Column	Type	Description
run_idPK	INT	Unique model run identifier
model_id	INT	Referenced dbt model
status	VARCHAR(30)	Run status
started_at	TIMESTAMP	Run start timestamp
failed_tests	INT	Number of failed tests for the run

Your question is Snowflake and dbt Experience. Start with the requirements and the two tables 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