Quick-reference guides for data engineers — 8 cheat sheets across 6 categories. From Snowflake SQL syntax to dbt commands, Airflow DAG patterns, window functions, interview questions, and production best practices — bookmark these for fast lookups during development and interview prep.
Complete reference for dbt CLI commands, Jinja macros, model selection syntax, and project configuration. Covers dbt Core and dbt Cloud.
IntermediateEssential Airflow CLI commands, DAG patterns, operators, and best practices for orchestrating data pipelines.
IntermediateEssential Snowflake SQL commands, functions, and syntax for data engineers. Covers DDL, DML, querying, and Snowflake-specific features.
IntermediateMaster ROW_NUMBER, RANK, LEAD, LAG, running totals, and moving averages. Works across Snowflake, BigQuery, Postgres, and Redshift.
IntermediateWant to test these patterns interactively? Try our free data engineering calculators and SQL playground.
For hands-on tutorials and guides, browse the full article library.