Astronomer ProvidersCertified

A client to interact with Snowflake.

Access Instructions

Install the Astronomer Providers provider package into your Airflow environment.

Import the module into your DAG file and instantiate it with your desired params.


snowflake_conn_idReference to Snowflake connection id
accountsnowflake account name
authenticatorauthenticator for Snowflake. ‘snowflake’ (default) to use the internal Snowflake authenticator ‘externalbrowser’ to authenticate using your web browser and Okta, ADFS or any other SAML 2.0-compliant identify provider (IdP) that has been defined for your account ‘’ to authenticate through native Okta.
warehousename of snowflake warehouse
databasename of snowflake database
regionname of snowflake region
rolename of snowflake role
schemaname of snowflake schema
session_parametersYou can set session-level parameters at the time you connect to Snowflake


A client to interact with Snowflake.

This hook requires the snowflake_conn_id connection. The snowflake host, login, and, password field must be setup in the connection. Other inputs can be defined in the connection or hook instantiation. If used with the S3ToSnowflakeOperator add ‘aws_access_key_id’ and ‘aws_secret_access_key’ to extra field in the connection.

Was this page helpful?