Snowflake
IP RESTRICTIONS
Make sure to allow traffic from one of the Paradime IPs in your firewall depending on the data location selected.
👉 See also: Paradime IP addresses.
Suggested permissions
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
Add Development Connection
You will be prompted to add a Development connection during the onboarding, or you can add more connections by going to account settings > connections, select Development Environment and enter the required fields.
Using Username & Password
Field Details
Below are list of fields and example to create a connection.
🏢
Workspace level
fields are set by the the workspaceAdmin
and not configurable for by user👥
User level
fields are set by each user (Admin
/Developer
) when setting the Development connection.
Field | Description | Example | Level |
---|---|---|---|
Profile Name | The profile name set in your |
| 🏢 Workspace level |
Target | The target name used to identify the connection. See more here. |
| 🏢 Workspace level |
Account | The Snowflake account to connect to as per Snowflake's documentation. |
| 🏢 Workspace level |
Role | The role to assume when running queries as the specified user. |
| 👥 User level |
Database | The name of your Snowflake development database. |
| 👥 User level |
Warehouse | The virtual warehouse to use for running queries. |
| 👥 User level |
Username | The username of the user. |
| 👥 User level |
Password | The password set for the user |
| 👥 User level |
Dataset | The default dataset used to build dbt™️ objects at runtime. |
| 👥 User level |
Threads | The number of threads used in this connection. See more here. |
| 👥 User level |
Using Snowflake OAuth
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.
Snowflake OAuthFields Details
Below are list of fields and example to create a connection.
🏢
Workspace level
fields are set by the the workspaceAdmin
and not configurable for by user👥
User level
fields are set by each user (Admin
/Developer
) when setting the Development connection.
Field | Description | Example | Level |
---|---|---|---|
Profile Name | The profile name set in your |
| 🏢 Workspace level |
Target | The target name used to identify the connection. See more here. |
| 🏢 Workspace level |
Account | The Snowflake account to connect to as per Snowflake's documentation. |
| 🏢 Workspace level |
Client ID | The Client ID generated when setting up the OAuth credentials. |
| 🏢 Workspace level |
Client Secret | The Client Secret generated when setting up the OAuth credentials. |
| 🏢 Workspace level |
Role | The role to assume when running queries as the specified user. |
| 👥 User level |
Database | The name of your Snowflake development database. |
| 👥 User level |
Warehouse | The virtual warehouse to use for running queries. |
| 👥 User level |
Dataset | The default dataset used to build dbt™️ objects at runtime. |
| 👥 User level |
Threads | The number of threads used in this connection. See more here. |
| 👥 User level |
Using Key-Pair authentication
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.
After generating an encrypted or unencrypted key pair,, you will need to set the rsa_public_key
for the Snowflake user connecting to Paradime.
Fields Details
Below are list of fields and example to create a connection.
🏢
Workspace level
fields are set by the the workspaceAdmin
and not configurable for by user👥
User level
fields are set by each user (Admin
/Developer
) when setting the Development connection.
Field | Description | Example | Level |
---|---|---|---|
Profile Name | The profile name set in your |
| 🏢 Workspace level |
Target | The target name used to identify the connection. See more here. |
| 🏢 Workspace level |
Account | The Snowflake account to connect to as per Snowflake's documentation. |
| 🏢 Workspace level |
Role | The role to assume when running queries as the specified user. |
| 👥 User level |
Database | The name of your Snowflake development database. |
| 👥 User level |
Warehouse | The virtual warehouse to use for running queries. |
| 👥 User level |
Username | The username of the user. |
| 👥 User level |
Private Key | The Private Key generated and linked to the user. You must include the commented lines when adding the Private Key. |
| 👥 User level |
Private Key Passphrase (Optional) | The Passphrase created when generating the encrypted key |
| 👥 User level |
Dataset | The default dataset used to build dbt™️ objects at runtime. |
| 👥 User level |
Threads | The number of threads used in this connection. See more here. |
| 👥 User level |
Last updated