Skip to main content

Connection to Snowflake

Important

From November 2025, Snowflake will no longer support username and password connections! Instead of a password, a PAT token can be used. This documentation contains all the information and requirements necessary for using PAT.

The Snowflake Connection is an extension to dab Nexus. Therefore it must be licensed separately.

Overview​

In the overview you can see all Connections that currently exist. You can search for a specific Connection, adjust the column selection or create a new Connection with the button New Connection.


Fabric Mirrored Database​

Creation​

Go to Settings > Connections, click on New Connection and Snowflake. Enter a name for the new Connection.

Organization Name - you find the name of the organisation in your Snowflake account settings Account Name - you find the account name in your Snowflake account settings

Use Proxy - optional

  • Proxy Host: Hostname of the Proxy Server
  • Proxy Port: Port of the Proxy Server
  • Proxy Username: Username to authenticate the Proxy Server
  • Proxy Password: Passwort to authenticate the Proxy Server

Username and Authentication

  • Username and Programmatic Access token: enter the PAT token (all information on requirements and configuration for using the PAT can be found here)
  • JWT certificate: enter the Private Key File Path and the Private Key File Password
  • OAuth Token: enter the token value for OAuth

By clicking on Refresh Snowflake Databases the Connection will be established. Afterwards select a Database and a Warehouse. You can also Restrict schema using in task creation.

Test Connection - if the connection test fails, you'll get possible solutions. You can also see more details about the possible issue.

Permissions​

Note

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​

You can edit an existing Connection. Just click on their name in the overview and you get back to the settings of the Connection.


Deletion​

Important

The deletion of a Connection can affect active (scheduled) Tasks and may cause them to fail. This deletion cannot be undone.