Install PipeRider with the Snowflake connector and connect to a Snowflake data source.
pip install 'piperider[snowflake]'
Run the diagnose command in the dbt project
If you can successfully connect to Snowflake using dbt, PipeRider can also connect to Snowflake using the same profile settings. For details, please refer to the dbt Snowflake adapter documentation.
non-dbt use case is deprecated since v0.25.0
[?] What is your data source name?: SnowflakeProject
[?] Which data source would you like to connect to?:
Follow the prompts entering the required information.
After selecting Snowflake as your data source, you will be promoted for the following information:
- Authentication method
- Keypair (private key path, optional passphrase)
- SSO ('externalbrowser' or a valid Okta URL)
- Role (optional)
If multi-factor authentication (MFA) is enabled on your Snowflake account, you will receive a Duo push-notification prompting you to allow access to the data source when executing the following PipeRider functions:
To reduce the number of prompts you receive, Snowflake allows users to cache MFA tokens by enabling a setting at the account level.
If MFA is enabled on your Snowflake account, please ensure the following.
- The following package is installed:
pip install 'snowflake-connector-python[secure-local-storage]'
- For non-dbt projects:Edit .piperider/credentials.yml and add
- For dbt projects:Edit
~/.dbt/profilesand add the following line to the corresponding profile:
After configuring your connection settings, ensure that PipeRider can connect to your Snowflake data source.