Install PipeRider with the Snowflake connector and connect to a Snowflake data source.
Install PipeRider with the Snowflake connector.
pip install 'piperider[snowflake]'
Initialize a new PipeRider project using
piperider initand when promoted select Snowflake as the data source.
The following information is required.
- Role (optional)
What data source would you like to connect to?:
Please enter the following fields for snowflake
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:
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: