When used in combination, Airflow and Snowflake help data teams orchestrate and automate end-to-end ETL/ELT operations to power analytics insights and MLOps.

This technical cheat sheet contains core tips, along with code examples, to help you make the most of Airflow and Snowflake. You’ll learn:

• How to define a Snowflake Airflow connection using key-pair authentication
• Multiple options for executing SQL in Snowflake with Airflow
• Options for SQL parameterization with the SQLExecuteQueryOperator
• How to run Snowpark queries with @task.snowpark
• Methods for running data quality checks on Snowflake tables