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 OAuthauthentication 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 OAuthauthentication 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.