Before you start, note the following requirements:

• Give the user USAGE privilege for the warehouse.
• Give the user SELECT privilege for every table and view in the schema you would like to use for segmentation and personalization.

Add the following IP addresses to the relevant allowlist: 34.89.173.3, 34.89.137.140, 35.246.249.205, 185.4.123.112

Meeting these requirements ensures Emarsys' access to your database.

The first step in using Relational Data is to set up the connection between your database and Emarsys.

1. In the Emarsys platform, go to Add-ons > Relational Data > Connections.

2. In the top right corner in Connections, click Create New Connection.
3. Select Snowflake.
4. Configure your connection as follows:

• Connection name: the reference you want to give to your connection, can be the same as the database name.

• Account name: the name assigned to your account by Snowflake. In the hostname you received from Snowflake (after your account was provisioned), your account name is the entire string to the left of snowflakecomputing.com. Example: xy12345.us-east-1-gov.aws.
• Warehouse name: the name of the virtual warehouse existing in Snowflake.
• Schema: the name of the schema you want us to use when we connect to snowflake.
• Database name: the name of the database you want us to use when connecting.
• User name: the login name for the Snowflake user you want to use when connecting.
• Password: password for the Snowflake user you want to use when connecting.
• Connection parameters (optional): specific parameters you want to use, leave empty to use default parameters.

4. When you finished adding all the necessary data, Test your connection.
5. Click Save to create the connector you just set up.

You are done and can now either:

• create Relational Data segment templates
• define Relational Data reference fields