Snowflake

With the Snowflake collector function, you can collect data from a Snowflake database. You can configure this function with authentication and credentials to collect data from a Snowflake database, and write an SQL statement on what data to collect from the database.

Snowflake collector configuration

You can configure this function in the following settings:

Settings

Setting	Description

Setting	Description
Environment
Account identifier	Enter the account identifier of the Snowflake account URL. Enter only the `account_identifier` from the account URL (`account_identifier.snowflakecomputing.com)` in this field, as the request is sent as the full account URL.
Warehouse	Enter the name of the virtual warehouse.
Database name	Enter the name of the database.
Authentication Choose between the three authentication type from the dropdown field:
Password	Username - The username of the Snowflake user account. Password - The password of the Snowflake user account. Note! The Password field only accepts parameter reference and requires you to use https://infozone.atlassian.net/wiki/spaces/DAZ/pages/738197704.
Private key JWT	Username - The username of the Snowflake user account used for authentication. Private key - The private key used to authenticate the Snowflake user with JWT authentication. Note! The Private key field only accepts parameter reference and requires you to use https://infozone.atlassian.net/wiki/spaces/DAZ/pages/738197704.
OAuth	Username - The username of the Snowflake user account associated with the OAuth token. Password - The password of the Snowflake user account. Client ID - The OAuth client identifier for this Snowflake integration. Client Secret - The secret associated with the OAuth Client ID. OAuth server endpoint - The URL of the OAuth server that issues access tokens. Scope - The authorization and token endpoints allow the function to specify the access request scope using this parameter. The entered value must be expressed as a list of space-delimited, case-sensitive strings. Note! The Password and Client Secret field only accepts parameter reference and requires you to use https://infozone.atlassian.net/wiki/spaces/DAZ/pages/738197704.
SQL statement
SQL statement	Note! Ensure that the tables of your database are populated with the correct data for collection. Enter the SQL statement to collect the data from the Snowflake database. Only a single `SELECT` statement is allowed. Note! https://infozone.atlassian.net/wiki/spaces/DAZ/pages/7861573 or interpolation is not supported.

Input/Output data

Input data

None.

Output data

The data collected from the Snowflake database according to the configuration of the function.

Below is a sample of data collected from a Snowflake database.

Sample data collected from Snowflake database

[
    {
        "C_CUSTOMER_SK": 28437730,
        "C_CUSTOMER_ID": "AAAAAAAACOMOBLBA",
        "C_CURRENT_CDEMO_SK": 854203,
        "C_CURRENT_HDEMO_SK": 2961,
        "C_CURRENT_ADDR_SK": 28176519,
        "C_FIRST_SHIPTO_DATE_SK": 2451242,
        "C_FIRST_SALES_DATE_SK": 2451212,
        "C_SALUTATION": "Dr.",
        "C_FIRST_NAME": "Cheryl",
        "C_LAST_NAME": "Ramsey",
        "C_PREFERRED_CUST_FLAG": "N",
        "C_BIRTH_DAY": 16,
        "C_BIRTH_MONTH": 1,
        "C_BIRTH_YEAR": 1965,
        "C_BIRTH_COUNTRY": "MYANMAR",
        "C_LOGIN": null,
        "C_EMAIL_ADDRESS": "Cheryl.Ramsey@uaq4mXuuV3.org",
        "C_LAST_REVIEW_DATE": "2452359"
    },
    {
        "C_CUSTOMER_SK": 28437731,
        "C_CUSTOMER_ID": "AAAAAAAADOMOBLBA",
        "C_CURRENT_CDEMO_SK": 1107909,
        "C_CURRENT_HDEMO_SK": 3831,
        "C_CURRENT_ADDR_SK": 28930953,
        "C_FIRST_SHIPTO_DATE_SK": 2449681,
        "C_FIRST_SALES_DATE_SK": 2449651,
        "C_SALUTATION": "Dr.",
        "C_FIRST_NAME": "Tamara",
        "C_LAST_NAME": "Schroeder",
        "C_PREFERRED_CUST_FLAG": "N",
        "C_BIRTH_DAY": 12,
        "C_BIRTH_MONTH": 2,
        "C_BIRTH_YEAR": 1956,
        "C_BIRTH_COUNTRY": "CAPE VERDE",
        "C_LOGIN": null,
        "C_EMAIL_ADDRESS": "Tamara.Schroeder@5cpi5t4he.edu",
        "C_LAST_REVIEW_DATE": "2452307"
    },
    {
        "C_CUSTOMER_SK": 28437732,
        "C_CUSTOMER_ID": "AAAAAAAAEOMOBLBA",
        "C_CURRENT_CDEMO_SK": 1465719,
        "C_CURRENT_HDEMO_SK": 6324,
        "C_CURRENT_ADDR_SK": 16092176,
        "C_FIRST_SHIPTO_DATE_SK": 2449602,
        "C_FIRST_SALES_DATE_SK": 2449572,
        "C_SALUTATION": "Mr.",
        "C_FIRST_NAME": "Robert",
        "C_LAST_NAME": "Sullivan",
        "C_PREFERRED_CUST_FLAG": "Y",
        "C_BIRTH_DAY": 22,
        "C_BIRTH_MONTH": 10,
        "C_BIRTH_YEAR": 1965,
        "C_BIRTH_COUNTRY": "VANUATU",
        "C_LOGIN": null,
        "C_EMAIL_ADDRESS": "Robert.Sullivan@v8uQNvOR9P7TZ.com",
        "C_LAST_REVIEW_DATE": "2452631"
    },
    {
        "C_CUSTOMER_SK": 28437733,
        "C_CUSTOMER_ID": "AAAAAAAAFOMOBLBA",
        "C_CURRENT_CDEMO_SK": 386019,
        "C_CURRENT_HDEMO_SK": 3750,
        "C_CURRENT_ADDR_SK": 39012328,
        "C_FIRST_SHIPTO_DATE_SK": 2450153,
        "C_FIRST_SALES_DATE_SK": 2450123,
        "C_SALUTATION": "Mrs.",
        "C_FIRST_NAME": "Margaret",
        "C_LAST_NAME": "Stephens",
        "C_PREFERRED_CUST_FLAG": "N",
        "C_BIRTH_DAY": 29,
        "C_BIRTH_MONTH": 6,
        "C_BIRTH_YEAR": 1927,
        "C_BIRTH_COUNTRY": "EQUATORIAL GUINEA",
        "C_LOGIN": null,
        "C_EMAIL_ADDRESS": "Margaret.Stephens@9GXtzt1X3f.edu",
        "C_LAST_REVIEW_DATE": "2452602"
    },
    {
        "C_CUSTOMER_SK": 28437734,
        "C_CUSTOMER_ID": "AAAAAAAAGOMOBLBA",
        "C_CURRENT_CDEMO_SK": 1091543,
        "C_CURRENT_HDEMO_SK": 6927,
        "C_CURRENT_ADDR_SK": 36141064,
        "C_FIRST_SHIPTO_DATE_SK": 2449815,
        "C_FIRST_SALES_DATE_SK": 2449785,
        "C_SALUTATION": "Mrs.",
        "C_FIRST_NAME": "Priscilla",
        "C_LAST_NAME": "Thomas",
        "C_PREFERRED_CUST_FLAG": "N",
        "C_BIRTH_DAY": 27,
        "C_BIRTH_MONTH": 3,
        "C_BIRTH_YEAR": 1959,
        "C_BIRTH_COUNTRY": "IRELAND",
        "C_LOGIN": null,
        "C_EMAIL_ADDRESS": "Priscilla.Thomas@7h0xtrRBo.edu",
        "C_LAST_REVIEW_DATE": "2452358"
    },
    {
        "C_CUSTOMER_SK": 28437735,
        "C_CUSTOMER_ID": "AAAAAAAAHOMOBLBA",
        "C_CURRENT_CDEMO_SK": 1748087,
        "C_CURRENT_HDEMO_SK": 5737,
        "C_CURRENT_ADDR_SK": 2761787,
        "C_FIRST_SHIPTO_DATE_SK": 2450264,
        "C_FIRST_SALES_DATE_SK": 2450234,
        "C_SALUTATION": "Sir",
        "C_FIRST_NAME": "Robert",
        "C_LAST_NAME": "Wong",
        "C_PREFERRED_CUST_FLAG": "N",
        "C_BIRTH_DAY": 7,
        "C_BIRTH_MONTH": 9,
        "C_BIRTH_YEAR": 1972,
        "C_BIRTH_COUNTRY": "SAMOA",
        "C_LOGIN": null,
        "C_EMAIL_ADDRESS": "Robert.Wong@J8OBd6dO4n3c5.edu",
        "C_LAST_REVIEW_DATE": "2452379"
    },
    {
        "C_CUSTOMER_SK": 28437736,
        "C_CUSTOMER_ID": "AAAAAAAAIOMOBLBA",
        "C_CURRENT_CDEMO_SK": 1867458,
        "C_CURRENT_HDEMO_SK": 2164,
        "C_CURRENT_ADDR_SK": 49569670,
        "C_FIRST_SHIPTO_DATE_SK": 2450691,
        "C_FIRST_SALES_DATE_SK": 2450661,
        "C_SALUTATION": "Mr.",
        "C_FIRST_NAME": "Efren",
        "C_LAST_NAME": "Seward",
        "C_PREFERRED_CUST_FLAG": "N",
        "C_BIRTH_DAY": 12,
        "C_BIRTH_MONTH": 5,
        "C_BIRTH_YEAR": 1981,
        "C_BIRTH_COUNTRY": "CÔTE D'IVOIRE",
        "C_LOGIN": null,
        "C_EMAIL_ADDRESS": "Efren.Seward@9aJAu4OODFr46SjMy.org",
        "C_LAST_REVIEW_DATE": "2452398"
    },
    {
        "C_CUSTOMER_SK": 28437737,
        "C_CUSTOMER_ID": "AAAAAAAAJOMOBLBA",
        "C_CURRENT_CDEMO_SK": 333092,
        "C_CURRENT_HDEMO_SK": 514,
        "C_CURRENT_ADDR_SK": 8049183,
        "C_FIRST_SHIPTO_DATE_SK": 2452296,
        "C_FIRST_SALES_DATE_SK": 2452266,
        "C_SALUTATION": "Ms.",
        "C_FIRST_NAME": "Kristal",
        "C_LAST_NAME": "Young",
        "C_PREFERRED_CUST_FLAG": "Y",
        "C_BIRTH_DAY": 10,
        "C_BIRTH_MONTH": 10,
        "C_BIRTH_YEAR": 1978,
        "C_BIRTH_COUNTRY": "ITALY",
        "C_LOGIN": null,
        "C_EMAIL_ADDRESS": "Kristal.Young@B5.edu",
        "C_LAST_REVIEW_DATE": "2452486"
    },
    {
        "C_CUSTOMER_SK": 28437738,
        "C_CUSTOMER_ID": "AAAAAAAAKOMOBLBA",
        "C_CURRENT_CDEMO_SK": 1120591,
        "C_CURRENT_HDEMO_SK": 3097,
        "C_CURRENT_ADDR_SK": 34798403,
        "C_FIRST_SHIPTO_DATE_SK": 2450144,
        "C_FIRST_SALES_DATE_SK": null,
        "C_SALUTATION": "Mrs.",
        "C_FIRST_NAME": "Nanci",
        "C_LAST_NAME": null,
        "C_PREFERRED_CUST_FLAG": null,
        "C_BIRTH_DAY": 4,
        "C_BIRTH_MONTH": null,
        "C_BIRTH_YEAR": 1954,
        "C_BIRTH_COUNTRY": null,
        "C_LOGIN": null,
        "C_EMAIL_ADDRESS": "Nanci.Rosas@sM85z9UsJ7.com",
        "C_LAST_REVIEW_DATE": "2452308"
    },
    {
        "C_CUSTOMER_SK": 28437739,
        "C_CUSTOMER_ID": "AAAAAAAALOMOBLBA",
        "C_CURRENT_CDEMO_SK": 1303958,
        "C_CURRENT_HDEMO_SK": 3495,
        "C_CURRENT_ADDR_SK": 20579385,
        "C_FIRST_SHIPTO_DATE_SK": 2449380,
        "C_FIRST_SALES_DATE_SK": 2449350,
        "C_SALUTATION": "Sir",
        "C_FIRST_NAME": "James",
        "C_LAST_NAME": "Ferguson",
        "C_PREFERRED_CUST_FLAG": "N",
        "C_BIRTH_DAY": 18,
        "C_BIRTH_MONTH": 2,
        "C_BIRTH_YEAR": 1954,
        "C_BIRTH_COUNTRY": "ROMANIA",
        "C_LOGIN": null,
        "C_EMAIL_ADDRESS": "James.Ferguson@z0VRblqtg.edu",
        "C_LAST_REVIEW_DATE": "2452555"
    }
]

Snowflake

Settings

Authentication

SQL statement

Input/Output data

Input data

Output data