Ingest data from Snowflake

This article explains how to ingest data into CDF from a Snowflake database, authenticating with OAuth 2.0 in the DB extractor. You must use Microsoft Entra ID as the OAuth 2.0 provider for Snowflake.

Before you start

Connect the DB extractor to a Snowflake database. Follow the steps in Knowledge Base Article from Snowflake

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}