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.
We advise creating a new Snowflake user and grant the suggested access required to create tables and views your Production database.
Create a new Snowflake user
You can execute the SQL commands below in Snowflake and create a user with the suggested access credentials.
Suggested Permissions
This set of permissions will enable Paradime to read from and create tables and views when running production jobs in you Snowflake database.
Add Production Connection
To add the Snowflake Production connection, go to account settings > connections, select Production Environment and enter the required fields.
Using Username & Password
Fields Details
Below are list of fields and example to create a connection.
Field | Description | Example |
---|---|---|
Profile | The profile name set in your |
|
Target | The target name used to identify the connection. See more here. |
|
Account | The Snowflake account to connect to as per Snowflake's documentation. |
|
Role | The role to assume when running queries as the specified user. |
|
Database | The name of your Snowflake production database. |
|
Warehouse | The virtual warehouse to use for running queries. |
|
Username | The username created with access to the production database. |
|
Password | The password set for the user created in Snowflake. |
|
Schema | The default schema used to build dbt™️ objects at runtime. |
|
Threads | The number of threads used in this connection. See more here. |
|
Using Key-Pair authentication
In Paradime you can use Key-Pair authentication method to connect your production 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.
Field | Description | Example |
---|---|---|
Profile | The profile name set in your |
|
Target | The target name used to identify the connection. See more here. |
|
Account | The Snowflake account to connect to as per Snowflake's documentation. |
|
Role | The role to assume when running queries as the specified user. |
|
Database | The name of your Snowflake production database. |
|
Warehouse | The virtual warehouse to use for running queries. |
|
Username | The username created with access to the production database. |
|
Private Key | The Private Key generated and linked to the user. You must include the commented lines when adding the Private Key. |
|
Private Key Passphrase (Optional) | The Passphrase created when generating the encrypted key |
|
Schema | The default schema used to build dbt™️ objects at runtime. |
|
Threads | The number of threads used in this connection. See more here. |
|
Last updated