Overview
Automatically ingest usage events into Sequence from your data warehouse
Sequence integrates with your data warehouse and lets you set up automated imports of your usage data, which is often the simplest and most scalable way to send usage data to Sequence.
Usage Data Schema
In Sequence, usage events have the following schema:
| Field | Description | Data Type | Mode |
|---|---|---|---|
eventType | Top-level category for the event | STRING | Required |
customerAlias | Alias for the customer the event belongs to | STRING | Required |
eventTimestamp | Defaults to ingestion time | TIMESTAMP | Optional |
customerEventId | Auto-generated if not provided | STRING | Optional |
eventProperties | Event metadata key-value pairs | JSON | Optional |
While your source table is not required to match this schema, it should have a well-defined mapping onto it. Get in touch with the Sequence team to discuss the most appropriate schema for your import source, and how to map it to the Sequence data model.
Import frequency
By default Sequence imports run once a day, but higher frequencies up to once every 15 minutes are supported. Get in touch with the Sequence team to set up a custom frequency.
Setting up your source
To get started, you will need to set up external access to your source table and share credentials with the Sequence team. See the sections below for step-by-step instructions specific to your data warehouse.