Best practice
https://www.astronomer.io/docs/learn/airflow-snowflake/
- To reduce costs and improve the scalability of your Airflow environment, consider using the SnowflakeSqlApiOperator in deferrable mode for long running queries.
https://www.astronomer.io/docs/learn/airflow-snowflake/