Skip to main content

​
Before you start

Connect the DB extractor to a Snowflake database. Follow the steps in the Knowledge Base Article from Snowflake about creating external OAuth tokens using Azure AD for the OAuth client.
When the connection is set up, use these attributes to configure the DB extractor:
  • Client ID
  • Client secret
  • Token endpoint
  • OAuth scopes

​
Configuration example

This is a configuration example for a Snowflake database using OAuth. 
databases:
  - name: Snowflake_OAuth
    type: snowflake
    authentication_type: oauth
    
    # Credentials
    client-id: ${Client ID}
    client-secret: ${Client Secret}
    access_token_generate_url: ${Token Endpoint}
    oauth_scopes: ${OAuth Scopes}

    # Account Info
    account: ${Snowflake Account ID}
    organization: ${Snowflake Organization ID}
    database: ${Snowflake Database}
    schema: ${Snowflake Schema}
    compute-warehouse: ${Snowflake Compute Warehouse}