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 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 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 Authentication).
- 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.