Faraday’s pre-built integration with Snowflake as a source allows you to share your Snowflake data with your Faraday account.

Doing so, we can utilize your lead, customer, and churn data for predictive outcomes, e.g. lead generation, lead conversion, or likelihood to churn.

Granting access

Requirements:

-Snowflake Account Name

-Snowflake User, with ACCOUNTADMIN permissions, and user's RSA_PUBLIC_KEY set to the key we provide below

-Snowflake Warehouse name

-Snowflake Database name

-Snowflake Schema name (default / none specified may mean "PUBLIC")

-Snowflake table name

-Incremental column* (helpful, but not required)

  1. Tell your Account Manager you'd like to setup Snowflake as a Source.
  2. You will need to set Faraday's public key to the RSA keypair, as shown below.
$ cat snowflake.pub 
-----BEGIN PUBLIC KEY-----
MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAqK472zUI+w0KRy6X2fgY
2Et/cyS65rgnh5DA1krBu9wKED7XhluWm/waaMkGIQrLqboU+Do4GBl4EM9sm8rk
NZoIbrTiEfC7W8B5n2Q8DQXIHT+bLOYOCDAqECZT5UH8KLMUbmVzxmOTiaXN/rLp
ZlI/Vz0vv/av5p+46+H36a4dFxAribYnSEWWpTOpBRwUVX/qG8vTKknArBEPdIBL
WyHSALbxNAN4YrwU9H+puTgw6tMsFKSCoUv3b+7mT5LAwztRx+pNC7BqCTYVvBZV
tstO7QHiZG2wbnjti+G/CTfLLodPIZljEGPJJM+i0941tK8ZIMaPYGe2snPumtKx
ywIDAQAB
-----END PUBLIC KEY-----

3. Login to your Snowflake system, https://www.snowflake.com/login/

4. Get the Snowflake Account Name from the URL, everything before

snowflakecomputing.com, in this case: qo71195.us-east-2.aws

5. Next, we need a Faraday Snowflake user with ACCOUNTADMIN privileges

6. In the top-bar navigation, go to "Account" then "Users"

7. Select "+Create" to create a new user

8. Create the Snowflake username and have it named something like, Faraday - then set a password. Note: Advanced settings when creating the user are not required.

9. Under Preferences - set the Default role to "ACCOUNTADMIN" then hit finish

10. Next, go to "Worksheets" in the top-bar navigation

11. Using a new or existing worksheet, update the RSA_PUBLIC_KEY for the user-created. Faraday will provide an RSA_PUBLIC_KEY to use.

12. Click on Databases, and determine which Snowflake database name you want the resulting table to live in.

13. Finally, as mentioned, we just need a schema & table name for where your data resides.

To send us these details in a secure manner, you may navigate to https://app.faraday.io/sources, click "Create source", select "Snowflake AWS" and give it a descriptive name.

Then enter your configuration credentials here:

examples:

  • Incremental column: CREATED_AT
  • Snowflake username - e.g. faraday, with the provided RSA public key set in
  • Snowflake account name: qo71195.us-east-2.aws
  • Snowflake warehouse: COMPUTE_WH
  • Snowflake role (optional): LOADER
  • Snowflake table name: ORDERS
  • Snowflake schema name: PUBLIC
  • Snowflake database name: FDY

Notes: Incremental column is very helpful to us in configuring how your data is replicated, albeit, optional to send here. Snowflake role IS optional (noted), and often times the Snowflake schema will be PUBLIC if you don't have a specification for another schema you'd like us to utilize.

Did this answer your question?