Snowflake key
If the Database Type is Snowflake, select whether you will use Password or Private Key authentication to connect to the database.
We strongly suggest you use Private Key authentication, as Snowflake will be deprecating username/password authentication from November 2025. Read Using Snowflake key-pair authentication for more information.
A valid username for the database connection.
The password for the database connection. You can enter the password using one of the following methods:
- Use Password Manager: Select a managed password from the drop-down, or click Manage to open the Manage Passwords dialog (recommended). The dialog contains three tabs:
- Passwords: Create and manage named password entries. When adding a new entry, set the Password Type to one of the following:
- Internal: Store the password on the server. Select an Encryption Type of Encoded or KMS. When using KMS, also select a Master Key.
- External: Retrieve the password from a secret manager selected from the Secret Manager drop-down.
- Private Keys: Create and manage named private key entries for key-pair authentication. When adding a new entry, set the Private Key Type to one of the following:
- Internal: Enter the Private Key content directly, and optionally provide a Passphrase if the key is password-protected.
- External: Retrieve the private key from a secret manager selected from the Secret Manager drop-down.
- Secret Managers: Add and manage connections to third-party secret managers. Supported types include AWS Secrets Manager, Azure Key Vault, and GCP Secret Manager. Read Integrating Matillion ETL with secret managers for setup instructions.
- Passwords: Create and manage named password entries. When adding a new entry, set the Password Type to one of the following:
- Use Variable: Select this checkbox to use a variable for the password.
For a Snowflake database with Private Key selected as the Password Type, this property isn't used.
The private key for the database connection. Store the private key in the component, or create a managed entry for the private key using Manage Passwords (recommended).
The private key must be in PEM format. If your private key is password-protected, enter the password in the Private Key Password property.
Read Key-pair authentication and key-pair rotation in the Snowflake documentation for more information.
For a Snowflake database with Password selected as the Password Type, this property isn't used.