Key-pair authentication

Connect Snowflake to Paradime using key-pair authentication with a private key and, optionally, a private key passphrase. Set Target to match the environment you are configuring (dev, prod, or dinoai).

Available in: Code IDE, Bolt, and Agent environments.

Set up the key pair

After generating an encrypted or unencrypted key pair, set the rsa_public_key for the Snowflake user connecting to Paradime:

alter user john_user set rsa_public_key='MIIBIjANBgkqh...';

Field access levels apply only to the Code IDE environment: an Admin sets workspace-level fields, and each developer sets their own user-level fields. In the Bolt and Agent environments, an Admin sets all fields.

Field details

Field	Description	Example
Profile Name	The profile name set in your `dbt_project.yml`. See more here.	`dbt-snowflake`
Target	The target name used to identify the connection. See more here.	`dev`
Account	The Snowflake account to connect to, as per Snowflake’s documentation.	`vj71689.eu-west-2.aws`
Role	The role to assume when running queries as the specified user.	`transformer`
Database	The name of your Snowflake 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`
Schema	The default schema used to build dbt™ objects at runtime.	`dbt_john`
Threads	The number of threads used in this connection. See more here.	`8`

​Set up the key pair

​Field details

Set up the key pair

Field details