Documentation / Product / Integrations / Snowflake

Snowflake: Import Data

This workflow allows you to import data from a Snowflake table or view into Lytics, resulting in new user profiles or updates to fields on existing profiles.

Before you begin this workflow, you need to make sure that the database, schema, and table or view from which you would like to import data is shared with the Lytics Snowflake account. Please contact Lytics Support to proceed.

Integration Details

This integration leverages Snowflake's Secure Data Sharing to import table or view data. On every run, this workflow will:

  1. Run a query in Snowflake to unload data to a Lytics owned Google Cloud Storage (GCS) Bucket in CSV format.

  2. Import the file from GCS into the selected Lytics data stream.

Fields

Fields imported through Snowflake will require custom data mapping. For assistance mapping your custom data to Lytics user fields, please contact Lytics Support.

Configuration

Follow these steps to set up and configure an import of Snowflake data in the Lytics platform.

  1. Navigate to Snowflake in the Integrations section of Lytics. Snowflake logo
  2. Select Workflows from the menu on the left.
  3. Select Import Data from the list of workflows.
  4. Select the authorization you would like to use.
  5. Using the Source Type dropdown menu, select whether to import from a Snowflake table or view.
  6. Using the Source dropdown menu, select the table or view you wish to import.
  7. In the Timestamp Field text input, enter the name of the field containing the event timestamp. On continuous imports, the most recent time in this field will be saved. On the next import, only rows with a timestamp later than that value will be imported.
  8. Enter name of the Lytics Stream where the data will be imported.
  9. Select the Keep Updated checkbox to continuously run this import. If this option is selected, the a Timestamp Field must be provided.
  10. Click Start Import. snowflake configuration 2