SnowflakeHook
SnowflakeA client to interact with Snowflake.
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 account, 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