snowflakelogo.jpeg

Snowflake’s Data Cloud is powered by an advanced data platform provided as Software-as-a-Service (SaaS). Snowflake enables data storage, processing, and analytic solutions that are faster, easier to use, and far more flexible than traditional offerings. Store data about your customers, your business, or anything on Snowflake and export to a system of your choice to build analytics and reporting on top of your data.

With the direct integration of Blueshift and Snowflake, importing customer data, catalogs, and real-time customer interaction data (events) into your Blueshift account is done easily and builds an up to date 360 degree view of all your customers.

Note

Importing data via direct integration with Snowflake is currently available for customers with the 'Schemas' or 'Advanced Data' add on. For more information, reach out to your CSM.

Prerequisites

  • Before you can integrate with Blueshift, you must have your Snowflake account set up.
  • In order to import data from Snowflake, Blueshift must be able to access data. Decide whether you will provide Direct Access to the data (Read and Write Access) or through a Reader Account.
  • If you want to set up incremental import, you can either set up Change Data Capture using Table Streams in Snowflake or use a specific column in your Snowflake tables to identify the increment. 
  • During the set up, you will have to run some commands to create a user in Snowflake, assign the required permissions to the user, and give Blueshift permission to run APIs on your data warehouse. The user who runs these commands in Snowflake must have the CREATE and REPLACE Role privilege in Snowflake.

Set up integration

After you have set up the integration, you can create a task to import data.

To give Blueshift access to the data in Snowflake, complete the following steps:

  1. Sign in to the Blueshift app, and click Apps in the left navigation menu.
  2. Go to All Apps, search for, and select Snowflake.
  3. You can also go to Data Platform Apps and select Snowflake.
  4. Click Configure to view all the configured adapters.
  5. Click +ADAPTER to add an adapter.

    snowflake_adapter_name.png

  6. Add a Name for the adapter.  If you have multiple adapters, the adapter name helps you to identify the integration.
  7. For How would you like to import data from Snowflake?, select either Setup Direct Account Access or Setup Reader Account Access.
  8. Select the Is streams enabled? option if you have enabled change data capture using streams.
  9. Provide the details of the data warehouse and the user to access to the data warehouse. The commands required to create the required user in Snowflake are generated using this information.

    Note: You must enter the data warehouse details  (Warehouse name, Database Name, Schema Name, and so on) in exactly the same case as defined in Snowflake. Otherwise, an error might occur when you set up an import task.

    snowflake_adapter_warehouse.png

    Host URL of your data warehouse

    The URL to access your Snowflake warehouse. 

    For example, https://ab12345.ap-south-1.aws.snowflakecomputing.com

    If you are using Snowflake’s Snowsight View, go to Admin>Accounts>Locator to find the the hostname. Click the link icon besides the locator value of the Account you want to import data from.

    Role of the user

    The role of the user in Snowflake.

    Warehouse name

    The name of the data warehouse in Snowflake.

    Database name

    The database name in Snowflake.

    Schema name

    The schema name in Snowflake.

    Username

    The username of the user to access the Snowflake data.

    Password

    The password for the user.

  10. Go to Step 2 on the adapter screen. Use the commands provided to create a user in Snowflake and assign the required permissions to the user.

    Note: The user who runs these commands in Snowflake must have the CREATE and REPLACE Role privilege in Snowflake.

    snowflake_adapter_setup_user.png

    1. Click the Copy to Clipboard icon to copy the commands.
    2. In the commands provided, edit the BLUESHIFT_PASSWORD and replace <ENTER_YOUR_PASSWORD_HERE> with the Password you provided in the data warehouse details in step 9.
    3. Log into your Snowflake account, go to Worksheets, and run the copied commands.
  11. Go to Step 3 on the adapter screen and give Blueshift permission to run APIs on your data warehouse.

    snowflake_adapter_api_permission.png

    1. Click Generate Public key.
    2. Click the Copy to Clipboard icon to copy the command.
    3. In your Snowflake account, go to Worksheets, and run the copied command.
    4. Click Check Access Status to verify that Blueshift can access the data.
  12. Click Save.

Note: There is a one to one mapping between the User and the token/public key generated while setting up the adapter. If the same User is used for two different adapters then access would work only for the adapter which has the latest token/public key. Hence it is recommended to have one User per adapter.

Additional Resources

Watch this video for a quick overview of the integration.

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.