Interactive Segment with Remote Table

This new feature allows users to create segments by Remote Table with Interactive Segment, without writing any SQL query.

How to Define a Remote Data Table

1. Access the Remote Data Table
   • Navigate to: Data Spaces > Tables > New > Remote Data Table.
2. Select a Remote Source
   • Choose the data source that contains the table you want to use.
3. Select a Schema
   • If "Pull With Table Name" is selected:
     • Enter the table name directly in the provided field.
   • If "Select From Schema" is selected:
     • Choose a schema from the listing page.
4. Select Columns
   • After selecting a table, its columns will be automatically fetched and listed.
   • Select one or more columns to use.
   • Ensure that one of the selected columns is a "Contact Key" column. Its type must be “Text” and “not Null”.

How to Access

1. Navigate to: Audience > Segments > New.
2. Select Interactive as the segment type.
3. Add a Name and Description for the segment.
4. Click Next to proceed to the Filters section.

How to Create Interactive Segment with Remote Table

1. In the Filters section, open the dropdown menu and choose Table Filter under Relational DB.
2. Select the desired table from the available list.
3. Click Add Filter to define the following:
   • Column: Choose the column you want to filter.
   • Operator: Select a condition, such as equals, contains, or greater than.
   • Value: Enter the value to filter by.
4. Once your filters are configured, click the Save button.

Prerequisites

1. Oracle, RedShift, MsSql and Google BigQuery data sources can use this feature.
2. Remote Source must be defined for utilizing the Remote Table on Interactive Segment.
3. Remote Table must be defined before utilizing the data on Interactive Segment.