This article describes how to add a new or edit an existing Snowflake database feed.


Contents

Process Overview

There are four stages that need to be completed when adding or editing a database feed:

  • Connection
  • Import Configuration 
  • Destination
  • Trigger

To find out how to create new and edit existing data feeds, see Data Sources overview.


Connection

When setting up a connection, you can either use an existing connection or create a new one.

If you are using an existing connection, you can leave the configuration parameters as they are or edit them.


To use an existing connection:

  1. At the Connection stage, from the Select Connection dropdown, choose the required connection.
    The dropdown will be empty if there have not been any previous connections configured.
  2. Enter the required connection parameters.
    See below for details.
  3. Click SAVE to save the parameters and move to the next step.


To create a new connection:

  1. At the Connection stage, click NEW CONNECTION.
  2. Enter the required connection parameters.
    See below for details.
  3. Click SAVE to save the parameters and move to the next step.


Connection Parameters

To make a connection to your chosen Snowflake database or edit the details of an existing connection, complete these details:

  • Connection Name
    Enter a suitable name for the connection using alphanumeric characters.
  • Database Host
    Enter the database host name.
    This is your Snowflake account ID, plus the Snowflake URL:
        <account_name>.snowflakecomputing.com
        <account_name>.<region>.snowflakecomputing.com
  • Database Port
    The default Database Port is 443.
  • Database Username
    See your Snowflake account for details.
  • Database Password
    See your Snowflake account for details.
  • Database Name
    See your Snowflake account for details.
  • Database Role (optional)
    The Database Role that you want to use for this connection.
  • Warehouse Name
    This is the virtual warehouse that is used once connected.
    The user must have the required role privileges to access the data warehouse.


Import Configuration

Once a connection has been established and a table selected, the feed has to be configured so that data is updated and filtered in the most suitable way.

Selecting a table

Once a table is selected, you can:

  • Preview the table data.
  • Configure the load data type:
    • Truncate and insert
    • Incremental
    • Update and insert (upsert)

For more information, see Data feed load types.

  • Filter fields by operator and value.
  • Add a primary key.
    This is only mandatory for an upsert feed. 
  • Name the feed.

Naming the feed

Follow these guidelines when naming a feed:

  • The name should be meaningful.
  • Only use alphanumeric characters and underscores.
  • It must start with a letter.
  • It must not end with an underscore.
  • Use up to 50 characters.


Destination

  • The Destination stage enables you to choose a where your data will be stored.
  • If there are multiple options available, you can choose multiple destinations for Redshift users Redshift and S3 (external table) and for the Snowflake users Snowflake and S3 (external table).
  • For more information, see Choosing a destination for a data connector.
  • Schema generated can be modified if needed.


Setting a trigger

For a guide to setting triggers for your data feeds, see How to create a trigger for a data feed.