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 Using Visual Builder
      • Audience Filters
      • Campaign Event Filters
      • Creating Audience Using SQL Builder
      • Managing Audiences
      • Sync Schedule
      • Audience Insights
    • Campaigns
      • Overview
      • Building a Campaign
      • Campaign Reports
        • Glossary
      • Conversion Tracking
  • Profiles
    • User Profile View
  • Traits
    • Use Cases
    • Calculated Traits
      • Advanced Mode
    • Dynamic Traits
  • 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
  • Sync Schedules
  • Audit Logs
  • Subscription Groups And Contact Fields
  • Delivery Controls
  • Alerts
  • Handlebars
  • Test Profiles
  • 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 Events Table

PreviousSetting Up Related TableNextCustom Properties

Last updated 7 months ago

Was this helpful?

Event definition is a one-time step. You can complete event setup by following these steps:

  1. Event table must be created in relation to an existing table. Click the + button on any existing table and Select events.

  1. Sortment prompts you to select a table in your data warehouse.

  1. Enter a name for your event table. Use something that helps you identify it easily later

  2. Optionally, enter a description.

  3. Choose the Primary Key column in your events table.

  4. Click Next.

  1. Choose how your events are stored in the table. If there are multiple events in the same table, choose the field with column names and label your events. This will help in making events data readable when querying on it for Audiences.

The schema overview page shows the schema from the perspective of primary table; labels are displayed accordingly.

Label the fields in your events table. These can be used to filter on events data in Audiences.9. Define the events relationship. Select the relationship's cardinality: 1:1, 1:many, or many:1. In most cases, primary tables have a 1:many relationship with events.10. Click Save to add the table to your schema.