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.
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)
Tell your Account Manager you'd like to set up Snowflake as a Source.
You’ll need to set Faraday's public key to the RSA keypair, as shown below:
$ cat snowflake.pub
-----BEGIN PUBLIC KEY-----
-----END PUBLIC KEY-----
Log into your Snowflake account.
Get the Snowflake Account Name from the URL, which is everything before snowflakecomputing.com, in this case: qo71195.us-east-2.aws
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.
Next, go to Worksheets in the top-bar navigation.
Using a new or existing worksheet, update the RSA_PUBLIC_KEY for the user created. Faraday will provide an RSA_PUBLIC_KEY to use.
Click on Databases, and determine which Snowflake database name you want the resulting table to live in.
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.
Search for Snowflake (AWS) as a Source location, enter a descriptive name, and click Next.
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.
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
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!