Snowflake Bulk Loading Using OAuth

Version:

2023.1

Last modified: May 17, 2023

Authentication Set Up

In Designer, drag the Output tool onto the canvas.

Select the Use Data Connection Manager (DCM) checkbox.
Select Set Up a Connection.
In the Data Connections window, go to Data sources and choose Snowflake Bulk.
The Bulk Connection window opens. Choose Local for Staging Method and select Set Up a Connection.
Select + Add Data Source.
When adding a Data Source, you can choose the connection with or without DSN.

Choose the DSN Technology, enter the Data Source Name and choose the prepared Snowflake OAuth DSN.
Select Save.
To link the credentials select + Connect Credential.
You can choose User name and password or OAuth as an Authentication Method.
For OAuth authentication method choose OAuth Application (for more information, see the Snowflake OAuth 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 Connect and on the Bulk Connection pop-up window select OK.
Sign in on the Snowflake manager external browser window.

Choose the DSN-less Technology from the dropdown.
Select Add Data Source.
Enter:
1. Data Source Name
2. Server
3. Database
4. Schema
5. Warehouse
Select Save.
To link the credentials, select + Connect Credential.
You can choose User name and password or OAuth as an Authentication Method.
1. For OAuth authentication method choose OAuth Application (for more information, see the Snowflake OAuth 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 Connect and on the Bulk Connection pop-up window select OK.
Sign in on the Snowflake manager external browser window.

After successfull authentication you are able to choose the name for an output table and run the workflow.