Snowflake Streaming Connector Setup Guide (Early Access) | Early Access

Actions

We recommend the following Snowflake table configurations for the Snowflake Streaming connector:

Concurrent writing of tables by more than one feed or audience may result in performance errors.

Navigate to the Connector Marketplace and add a new connector. For general instructions on how to add a connector, see About Connectors.

After adding the connector, configure the following settings:

Username
The Snowflake account username.
Role
Access control role to use for the session.
URL
The Snowflake account URL in the following format: <account_identifier>.snowflakecomputing.com
Private Key
The customer-generated private key. For instructions on generating the Snowflake private key, see Snowflake > Key-pair authentication and key-pair rotation.

To complete the connector authentication, use the following steps to alter the above user with public key details in Snowflake:

Generate a public key in Snowflake. For information, see Generate a Public Key.
Assign the public key to the above user by using an ALTER USER command in Snowflake. Only owners of users or users with SECURITYADMIN roles or higher can alter a user. For more information, see Assign the public key to a Snowflake user.
To successfully assign the public key to the user, ensure the following:
- Enter the Snowflake username in double quotes ("). For example, "SNOWFLAKE.USER".
- Copy and paste the public key without line breaks.
Run the query to update the user with the new public key.

Snowflake supports public and private key rotations. For more information, see Configuring key-pair rotation.

The following section lists the supported parameters for each action.

Parameter	Description
Database Name	The Snowflake database that contains the required table.
Schema Name	The name of the schema used in the table.
Table Name	The name of the table you want to insert data into.
Event Parameters	Map the event parameters to the columns in the Snowflake table.

Parameter	Description
Database Name	The Snowflake database that contains the required table.
Schema Name	The name of the schema used in the table.
Table Name	The name of the table you want to insert data into.
Column to record the payload	Choose the VARIANT column to record the event data.

Parameter	Description
Database Name	The Snowflake database that contains the required table.
Schema Name	The name of the schema used in the table.
Table Name	The name of the table you want to insert data into.
Visitor Parameters	Map the visitor parameters to the columns in the Snowflake table.

Parameter	Description
Database Name	The Snowflake database that contains the required table.
Schema Name	The name of the schema used in the table.
Table Name	The name of the table you want to insert data into.
Column to record the visitor data	Choose the VARIANT column to record the visitor data.
Include Current Visit Data	Selecting this option will include both visitor data and current visit data in the data sent to Snowflake.