Skip to main content

[en] Snowflake OAuth Authentication

[en] The following steps will help you set up the native Snowflake OAuth authentication using the Input tool.

[en] Prerequisites

[en] To be able to set up Snowflake OAuth authentication you need:

  • [en] Valid DSN prepared with the Authenticator option set to oauth,

  • [en] OAuth authority URL, Port, Client ID, and Client Secret from the Snowflake administrator.

[en] Authentication Set Up

[en] In Designer, place the Input tool to the canvas.

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

  2. [en] Select Set Up a Connection.

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

  4. [en] The Connection Manager window pops up. Select + Add Data Source.

  5. [en] Fill in the Data Source Name and choose the prepared Snowflake OAuth DSN.

  6. [en] Select Save.

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

  8. [en] Choose OAuth as an Authentication Method.

  9. [en] For OAuth Application choose Create New Credential and fill in the information needed (you should get the OAuth authority URL, Port, Client ID and Client Secret from the Snowflake administrator).

  10. [en] Choose Create New Credential for OAuth Tokens.

  11. [en] Fill in the Credential Name and select Create and Link.

  12. [en] Select the Connect button and sign in on the Snowflake manager external browser window.

: