Snowflake
Last updated
Was this helpful?
Last updated
Was this helpful?
IP RESTRICTIONS
Make sure to allow traffic from one of the Paradime IPs in your firewall depending on the data location selected.
👉 See also: .
This set of permissions will enable users in Paradime to read from and create tables and views when running dbt™️ from the Paradime terminal in you Snowflake database.
The role connected in Paradime for should have the below permissions for each database where your source data lives and where you want to materialize your models. Make sure to
You will be prompted to add a Development connection during the onboarding, or you can add more connections by going executing the following instructions:
Click Settings in the top menu bar of the Paradime interface to access Account Settings
In the left sidebar, click "Connections"
Click "Add New" next to the Code IDE section
Select "Snowflake"
Below are list of fields and example to create a connection.
Profile Name
dbt-snowflake
Target
dev
Account
vj71689.eu-west-2.aws
Role
The role to assume when running queries as the specified user.
transformer
Database
The name of your Snowflake development database.
analytics
Warehouse
The virtual warehouse to use for running queries.
transforming
Username
The username of the user.
john_user
Password
The password set for the user
password_xyz
Dataset
The default dataset used to build dbt™️ objects at runtime.
dbt_john
Threads
8
Check our Tutorial on how to setup Snowflake OAuth in your Snowflake account. Once this connection is configured, each user will be redirected to Snowflake and asked to authenticate their connection.
Below are list of fields and example to create a connection.
Profile Name
dbt-snowflake
Target
dev
Account
vj71689.eu-west-2.aws
Client ID
The Client ID generated when setting up the OAuth credentials.
UPWBLFUTwT7hJ+JDbNthut3rF3w=
Client Secret
The Client Secret generated when setting up the OAuth credentials.
7FMKYoOP9+KUh2qqVHXfsZStUJLpiaa/ojFmvGwr06E=
Role
The role to assume when running queries as the specified user.
transformer
Database
The name of your Snowflake development database.
analytics
Warehouse
The virtual warehouse to use for running queries.
transforming
Dataset
The default dataset used to build dbt™️ objects at runtime.
dbt_john
Threads
8
In Paradime you can use Key-Pair authentication method to enabled users to connect their development environment using a Private Key and optionally a Private Key Passphrase.
Below are list of fields and example to create a connection.
Profile Name
dbt-snowflake
Target
dev
Account
vj71689.eu-west-2.aws
Role
The role to assume when running queries as the specified user.
transformer
Database
The name of your Snowflake development database.
analytics
Warehouse
The virtual warehouse to use for running queries.
transforming
Username
The username of the user.
john_user
Private Key
The Private Key generated and linked to the user. You must include the commented lines when adding the Private Key.
-----BEGIN ENCRYPTED PRIVATE KEY----- < private key content here > -----END ENCRYPTED PRIVATE KEY-----
Private Key Passphrase (Optional)
The Passphrase created when generating the encrypted key
passphrase_xyz
Dataset
The default dataset used to build dbt™️ objects at runtime.
dbt_john
Threads
8
The profile name set in your dbt_project.yaml
. See more .
The target name used to identify the connection. See more .
The Snowflake account to connect to as per
The number of threads used in this connection. See more .
The profile name set in your dbt_project.yaml
. See more .
The target name used to identify the connection. See more .
The Snowflake account to connect to as per
The number of threads used in this connection. See more .
After ,, you will need to set the rsa_public_key
for the Snowflake user connecting to Paradime.
The profile name set in your dbt_project.yaml
. See more .
The target name used to identify the connection. See more .
The Snowflake account to connect to as per
The number of threads used in this connection. See more .