Skip to main content

[en] Snowflake Bulk Loading Using OAuth

[en] Authentication Set Up

[en] In Designer, drag the Output tool onto the canvas.

  1. [en] Select the Use Data Connection Manager (DCM) checkbox.

  2. [en] Select Set Up a Connection.

  3. [en] In the Data Connections window, go to Data sources and choose Snowflake Bulk.

  4. [en] The Bulk Connection window opens. Choose Local for Staging Method and select Set Up a Connection.

  5. [en] Select + Add Data Source.

  6. [en] When adding a Data Source, you can choose the connection with or without DSN.

[en] Connection with DSN

  1. [en] Choose the DSN Technology, enter the Data Source Name and choose the prepared Snowflake OAuth DSN.

  2. [en] Select Save.

  3. [en] To link the credentials select + Connect Credential.

  4. [en] You can choose User name and password or OAuth as an Authentication Method.

  5. [en] For OAuthauthentication method choose OAuth Application (for more information, see the Snowflake OAuth article).

  6. [en] Now you can choose an existing token or Create New Credential for OAuth Tokens. For a new credential fill in the Credential Name.

  7. [en] Select Create and Link.

  8. [en] Select Connect and on the Bulk Connection pop-up window select OK.

  9. [en] Sign in on the Snowflake manager external browser window.

[en] Connection without DSN

  1. [en] Choose the DSN-less Technology from the dropdown.

  2. [en] Select Add Data Source.

  3. [en] Enter:

    1. [en] Data Source Name

    2. [en] Server

    3. [en] Database

    4. [en] Schema

    5. [en] Warehouse

  4. [en] Select Save.

  5. [en] To link the credentials, select + Connect Credential.

  6. [en] You can choose User name and password or OAuth as an Authentication Method.

    1. [en] For OAuthauthentication method choose OAuth Application (for more information, see the Snowflake OAuth article).

  7. [en] Now you can choose an existing token or Create New Credential for OAuth Tokens. For a new credential fill in the Credential Name.

  8. [en] Select Create and Link.

  9. [en] Select Connect and on the Bulk Connection pop-up window select OK.

  10. [en] Sign in on the Snowflake manager external browser window.

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

: