Snowflake Connection without DSN
You can use the Data Connection Manager (DCM) interface to capture all needed information and the driver to provide authentication. The data connection is shareable via Server, the connection string is saved in DCM instead of a workflow, and the workflow is shareable without being dependent on DSN.
Connection Set Up
Drag the Input Data tool onto the Designer canvas.
Select the Use Data Connection Manager (DCM) checkbox.
In the Data Connections window, go to Data sources and choose Snowflake ODBC.
The Connection Manager window opens. Select + Add Data Source.
From the dropdown, select the Snowflake ODBC DCN-less with Simba technology.
Select Add Data Source.
Enter the information:
Data Source Name
Server
Database
Schema
Warehouse
With Designer version 2024.1, the proxy parameter has been added to the Snowflake DCM schema.
Warning
Make sure to not include proxy credentials in the parameter. The value of this parameter is not encrypted and might be misused for malicious purposes.
Select Save.
To link the credentials, select + Connect Credential.
You can choose User name and password or OAuth as an Authentication Method.
For OAuthauthentication method choose OAuth Application (for more information, see the SnowflakeOAuth Authentication article).
Now you can choose an existing token or Create New Credential for OAuth Tokens. For a new credential fill in the Credential Name.
Select Create and Link.
Select the Connect button and sign in on the Snowflake manager external browser window.
Select Connect.
Choose any table from your database in the Query Builder.
Select OK.