Prerequisites:

• Snowflake Account credentials
• Warehouse with a database to be present in it should be there In the Snowflake account.

Set-up process:

Log in to your Datahash account on https://studio.datahash.com/login

Navigate to Warehouse category under Sources list in the left section.

Click on the “Snowflake” connector tile.

Choose the data entity as Snapchat Leads.


Once done, provide the connection name.



For this integration, click on “Snapchat Leads”. Provide a source name to your connection. Click Next.

There are 2 ways through which you can integrate namely:

Table Path: Choose this if you would like to provide the data in a table format specified by Datahash

Query path: Choose this if you would like to provide the SQL query to Datahash through which data needs to be pulled.

For Table Path:

Table Name: Provide the table name from where the data needs to be extracted. It should be a part of your dataset id provided.

In order to setup the connection successfully, kindly download the File Format which help you understand the overall structure in which you need to get the data setup.

The user needs to provide the credentials which will help Datahash to access the file for further processing. These credentials are:

User Account: Your Snowflake account ID. This is always found at the beginning of your Snowflake URL

Warehouse Name: The name of the Snowflake Warehouse to use for compute.

Database Name: The name of a database in your Snowflake account.

Schema Name: The name of the schema in your database.

Username: The user name for accessing your Snowflake database.

Password: The password for accessing your Snowflake database.

Table Name: The table name in your user schema.

Once all the credentials are provided, click on Validate Credentials & Datahash will validate the credentials, after which the connection will be successfully setup – if all the credentials are valid.

Click Finish to complete the setup.

For Query Path:

The only difference between query path and table path for authentication is the table name is not asked in Query path since the same will be provided in the SQL query. The user needs to provide the below mentioned credentials :

User Account: Your Snowflake account ID. This is always found at the beginning of your Snowflake URL

Warehouse Name: The name of the Snowflake Warehouse to use for compute.

Database Name: The name of a database in your Snowflake account.

Schema Name: The name of the schema in your database.

Username: The user name for accessing your Snowflake database.

Password: The password for accessing your Snowflake database.

Table Name: The table name in your user schema.

Once done, click on Validate Credentials. Datahash will validate the credentials.

If all looks good, click Next to continue.

You will land on the “Configure” screen where you are required to provide the SQL Query through which you want Datahash to extract the data.

Once done, click on Preview Results.

If everything looks good, click Finish to complete the setup. If the set-up is exited before finishing the set-up, the connector will remain in pending status and still be completed any time later by clicking the Connection Name in the below step.|

You can see the connected instance in the dashboard.

 You can access the set-up again by clicking on the edit button in the Snowflake widget.

The set-up configurations can be edited if required, from the Manage connections section.