Snowflake Bulk Loading Using OAuth
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.
Connection with 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.
Connection without DSN
-
Choose the DSN-less Technology from the dropdown.
-
Select Add Data Source.
-
Enter:
-
Data Source Name
-
Server
-
Database
-
Schema
-
Warehouse
-
-
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.
After successfull authentication you are able to choose the name for an output table and run the workflow.