Snowflake Connector

Install PipeRider with the Snowflake connector and connect to a Snowflake data source.

Installation
Install PipeRider with the Snowflake connector.
pip install 'piperider[snowflake]'
Prepare Credentials of Snowflake
Initialize a new PipeRider project using piperider init and when promoted select Snowflake as the data source.
The following information is required.
Account
Username
Password
Role (optional)
Database
Warehouse
Schema
piperider init
What data source would you like to connect to?:
> snowflake
Please enter the following fields for snowflake
Account:
Username:
Password:
Role (optional):
Database:
Warehouse:
Schema:
If you see the message Please run pip install piperider[snowflake] to get the snowflake connector this means that the Snowflake connector is not installed. Please follow the installation instructions above.
Multi-Factor Authentication (MFA)
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:
piperider diagnose
piperider run
MFA Token Caching
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 authenticator: username_password_mfa
For dbt projects:
Edit ~/.dbt/profiles and add the following line to the corresponding profile:
authenticator: username_password_mfa

Redshift Connector

Next - CLI

Data Quality Assertions

Last modified 4d ago