SnowflakeHook

Snowflake

A client to interact with Snowflake.

View on GitHub

Last Updated: Jan. 28, 2023

Access Instructions

Install the Snowflake provider package into your Airflow environment.

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

Parameters

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 https://.okta.com 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
insecure_modeTurns off OCSP certificate checks. For details, see: How To: Turn Off OCSP Checking in Snowflake Client Drivers - Snowflake Community

Documentation

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.

Note

get_sqlalchemy_engine() depends on snowflake-sqlalchemy

See also

For more information on how to use this Snowflake connection, take a look at the guide: SnowflakeOperator

Was this page helpful?