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,” or simply append Faraday data back into your Snowflake (AWS) account.

Granting access

To grant access, you’ll need the following items:

-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 set up Snowflake as a Source.

  2. You’ll 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-----

  1. Log into your Snowflake account.

  2. Get the Snowflake Account Name from the URL, which is everything before snowflakecomputing.com, in this case: qo71195.us-east-2.aws

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

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

  • Select +Create to create a new user.

  • 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.

  • Under Preferences - set the Default role to ACCOUNTADMIN, and hit Finish.

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

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

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

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

Sending credentials securely to Faraday:

Go to the Faraday app’s Sources console, click Create source at the top.

  1. Search for Snowflake (AWS) as a Source location, enter a descriptive name, and click Next.

  2. Enter your Snowflake details, and click Next.

    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.

    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

  3. Under Finalize, click Create source. Faraday can now begin the integration process. Once you finalize this source integration, our Customer Success team will be able to finish the configuration and we can begin utilizing your Snowflake data!

Did this answer your question?