Connection to Snowflake
From November 2025, Snowflake will no longer support username and password connections. Use one of the supported authentication methods instead, for example Programmatic Access Tokens (PAT), JWT, or OAuth. For requirements and configuration details for PAT, refer to the Snowflake documentation.
The Snowflake connector is an extension to dab Nexus and must be licensed separately.
Overview
Use this page to create a Snowflake connection in dab Nexus so that Snowflake databases can be selected during task creation.
Before you begin, make sure you have your Snowflake account details and one supported authentication method available.
In the Connections overview, you can see all existing connections, search for a specific connection, adjust the column selection, or create a new connection with New Connection.
Prerequisites
Before you create the connection, prepare the following information:
- A licensed Snowflake Connector for dab Nexus
- The Snowflake Organization Name and Account Name
- One supported authentication method and the required credentials:
- Programmatic Access Token: Snowflake username and PAT
- JWT certificate: Snowflake username, Private Key File Path, and Private Key File Password
- OAuth Token: OAuth token
- The Snowflake database and warehouse you want to use
- Optional proxy server details if your environment requires outbound traffic through a proxy
Create Connection
Go to Settings > Connections, click New Connection, and select Snowflake.
1. General information
Enter a name for the new connection.
- Organization Name: Find the organization name in your Snowflake account settings.
- Account Name: Find the account name in your Snowflake account settings.
2. Optional proxy settings
Enable Use Proxy only if the connection to Snowflake must be routed through a proxy server.
- Proxy Host: Hostname of the Proxy Server
- Proxy Port: Port of the Proxy Server
- Proxy Username: Username to authenticate the Proxy Server
- Proxy Password: Password to authenticate the Proxy Server
3. Authentication
Choose the authentication method that matches your Snowflake setup. Use one authentication method for each connection.
| Authentication Method | When to use it | Required input |
|---|---|---|
| Username and Programmatic Access Token | Recommended if you want to continue using a username-based sign-in after password authentication is no longer supported by Snowflake | Snowflake username and PAT |
| JWT certificate | Use this if your Snowflake environment is configured for key-pair authentication | Snowflake username, Private Key File Path, and Private Key File Password |
| OAuth Token | Use this if your organization provides OAuth-based access to Snowflake | OAuth token |
For PAT requirements and setup details, refer to the Snowflake documentation.
4. Load available databases
After you have entered the required connection details, click Refresh Snowflake Databases. This establishes the connection to Snowflake and loads the databases that are available for selection in dab Nexus.
5. Select database and warehouse
After the refresh is successful, select the Database and the Warehouse you want to use. If required, you can also restrict which schemas are available during task creation.
6. Test the connection
Use Test Connection to validate the configuration. If the connection test fails, dab Nexus shows possible solutions and additional details about the issue.
Permissions
If you don't select any Teams or Users, all Users of dab Nexus can use this connection. If you select one or more Teams or Users, only these can use the connection.
Edit
To edit an existing connection, click its name in the overview. The connection settings open again and can be updated.
Next Step
After a successful connection test, the connection is available during task creation.
Deletion
The deletion of a connection can affect active (scheduled) tasks and may cause them to fail. This deletion cannot be undone.