Docs
Sign up now
  • Getting started
    • Welcome to Sortment
    • Core Concepts
  • Schema
    • Overview
    • Related and Events Table
    • Setting Up Related Table
    • Setting Up Events Table
    • Custom Properties
  • ENGAGE
    • Audiences
      • Creating Audience
      • Audience Filters
      • Campaign Event Filters
      • Creating Audience Using SQL Builder
      • Managing Audiences
      • Audience Insights
    • Traits
      • Use Cases
      • Calculated Traits
        • Advanced Mode
      • Dynamic Traits
    • Profiles
      • User Profile View
    • Campaigns
      • Overview
      • Building a Campaign
      • Campaign Reports
        • Glossary
      • Conversion Tracking
  • Journeys
    • Getting Started
    • Journey Builder
    • Journey Components
      • Trigger
      • Delays
      • Flow Control
      • Action blocks
    • Tutorial: Creating a journey
    • Journey Settings
  • Connector
    • Overview
    • Getting started
      • Iterable
      • Klaviyo
  • Enable Data Sync
  • Setup
    • Data Warehouses
      • Snowflake
      • BigQuery
      • Redshift
      • Databricks
      • PostgreSQL
    • Cloud Bucket Storage
      • Amazon S3 for Snowflake
      • Google Cloud Storage for BigQuery
      • Amazon S3 for Redshift
      • Amazon S3 for Databricks
    • Communication Channels
      • Email
        • SendGrid
        • SES
        • Mailmodo
      • SMS
        • MSG91
        • Gupshup
      • WhatsApp
        • Meta (Facebook)
          • Add new Phone Number to Meta
        • Gupshup Enterprise
        • WATI
        • Gallabox
        • Yellow.ai
        • Kaleyra.io
    • Real-time Events
      • Setting up Event Source
      • Whitelist Event Payload
  • Settings
    • Sync Schedules
    • Audit Logs
    • Subscription Groups And Contact Fields
    • Delivery Controls
    • Test Profiles
    • Alerts
  • Data and Security
    • Technical Overview
    • Warehouse Data Practices
    • Data Access And Usage
    • Security Compliance
    • Audit Logs
    • Privacy Policy
Powered by GitBook
On this page

Was this helpful?

  1. Schema

Setting Up Related Table

PreviousRelated and Events TableNextSetting Up Events Table

Last updated 16 days ago

Was this helpful?

Related tables help you add more context on the users data in Sortment. Here's how you can add a related table, either from a connected warehouse or a CSV upload:

  1. In the Schema view, click the “Add table” button (top right of the canvas).

  2. Select “Add related table” from the dropdown.

  3. In the Setup step, choose your source:

    • Warehouse – Select this if you're linking to a table already synced with data warehouse.

    • CSV – Use this if you're uploading data from a CSV file.

For CSV upload make sure your file follows the format:

  • Headers must contain only letters, numbers, or underscores, No spaces or special characters are allowed in header names and each header must be ≤ 255 characters.

  • The CSV file must be less than 50MB in size.

  1. Once you've chosen the data source, you'll see a list of available tables. Select the relevant table (e.g., FMS_REFUNDS) and click Continue.

  1. Sortment may suggest a table name based on the table details. This will be helpful in identifying this table easily.

  2. Optionally, enter a description.

  3. Choose the Primary key column in your related table. This column should contain unique identifier for records in the table.

  4. Click Next.

  1. Configure the following table properties for each column:

    1. Visibility: Turn a column on or off depending on whether you want to use it in Sortment.

    2. Labels: Sortment will autosuggest labels and descriptions for your table. Label the fields in your events table. These can be used to filter on events data in Audiences.

    3. Descriptions (optional): Describe what your column contains.

    4. Masked toggle: Turn this on for sensitive information (e.g., personal identifiable data). Masked data will be protected and hidden by default in UI previews to comply with regulations and security.

    5. Cached toggle: Caching a column stores unique values from the column to make them accessible in the filter dropdowns.

  1. Once you've configured all the necessary properties, click “Save” to finish adding your related table. The new table will now appear in your schema. Now let's define this table's relation to other tables already existing in your schema.

Joining Tables

  1. Select the table you want to work with (e.g. User Information).

  2. Go to the relations tab to join the FMS_REFUNDS with User Information .

  1. Click connect table at the bottom.

  2. In the join setup:

  • Choose the column from the current table you want to join on (e.g. Id from User Information).

  • Select the join type (1:1, many:1, etc.).

  • Pick the column from the target table you want to join to (e.g. FMS ORDER ID from FMS_REFUNDS).

  1. Once your configuration is complete, click Save.

This will link the data across tables based on the selected keys, enabling richer queries and insights.