Skip to content

Snowflake

Set Host to your Snowflake account identifier, for example xy12345.us-east-1.

Authentication

Default port: 443 - Driver: dbc install snowflake

Auth type Fields you'll enter
password Username (Snowflake login name), Password (Password)
key_pair Username (Snowflake login name)

Extra parameters:

Parameter Applies to Description
schema All Snowflake schema.
warehouse All Snowflake warehouse.
role All Snowflake role.
login_timeout All Login timeout in seconds.
private_key_file key_pair Path to the RSA private key file.
private_key_passphrase key_pair Passphrase for an encrypted private key.

For key_pair authentication, generate an RSA key pair and assign the public key to a Snowflake service user, then point private_key_file at the private key on your side — see Snowflake's key-pair authentication guide.