Snowflake (collector)
The Snowflake collector function collects 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.
You can configure this function in the following settings:
Settings
Setting | Description |
|---|---|
Environment | |
Account identifier | Enter the account identifier of the Snowflake account URL. Enter only the |
Warehouse | Enter the name of the virtual warehouse. |
Database name | Enter the name of the database. |
Authentication | |
Select from secrets wallet | Select the secrets with the Snowflake secret type. |
OAuth server endpoint | Note! This option appears when the Snowflake secret has the OAuth 2.0 authentication type. Specify the URL containing the authorization token. |
Scope | Note! This option appears when the Snowflake secret has the OAuth 2.0 authentication type. 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. |
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 Note! Variable insertion 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.
[
{
"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"
}
]