Segment
Segment is Twilio's Customer Data Platform (CDP). It collects customer event data from websites, mobile apps, and server-side systems and routes it to analytics tools, marketing platforms, and data warehouse destinations.
Segment integration replicates data using the Segment Public API.
This connector replicates workspace configuration and operational metrics from Segment. It does not replicate raw analytics events (track, identify, page, screen, or group calls).
Preparing for authentication
To access your data, you need to authenticate the connection with a Segment Public API token.
To set up your Segment account, you need:
- An active Segment workspace on a Team or Business tier plan. Free and Starter plans have limited Segment Public API support, and some streams may return 403 errors.
- A Segment user with Workspace Owner or Workspace Member role (required to create API tokens).
To create an API token:
- Log into your Segment account.
- Navigate to Settings > Workspace settings.
- Select the Access Management tab.
- Click the Tokens tab.
- Click + Create Token.
- Enter a description for the token, for example QlikDataIntegration.
- Select Workspace Member access, which is sufficient for read-only access to workspace data.
- Click Create.
- Copy and paste your API token into a secured file.
Creating the connection
詳細については、「SaaSアプリケーションへの接続」を参照してください。
- 必要な接続プロパティを入力します。
接続名に接続の名前を入力します。
接続メタデータを開くを選択して、作成時の接続のメタデータを定義します。
[作成] をクリックします。
| Setting | Description |
|---|---|
| Data gateway | ユース ケースに応じて Data Movement gateway を選択します。 情報メモ Qlik Talend Cloud スターター サブスクリプションでは Data Movement gateway をサポートしていないため、この項目は使用できません。別のサブスクリプション ティアを利用しており、Data Movement gateway を使用しない場合は、 [None] (なし) を選択します。 Data Movement gateway の利点とそれを必要とするユース ケースの詳細については、「Qlik データ ゲートウェイ - データ移動」を参照してください。 |
| Start Date | ソースからターゲットにデータをレプリケートする必要がある日付を |
| API Token | API token. |
Limitations and considerations
- The Segment Public API requires a Team or Business tier plan for full access. Some endpoints may return 403 errors on Free or Starter plans.
- The
audit_eventsstream requires the Audit Trail feature, which is available on Business tier plans only. Team tier accounts and below should de-selectaudit_eventsbefore syncing to avoid 403 errors. - Usage metric streams (
usage_api_calls_per_source_daily,usage_api_calls_workspace_daily,usage_mtu_per_source_daily, andusage_mtu_workspace_daily) paginate through data month by month from the configured start date. The day-of-month component of the start date is ignored for these streams — data is fetched from the first day of the calendar month containing the start date. Initial syncs may take longer when the start date is set far in the past. - As of February 1, 2024, Segment no longer supports creating Config API tokens. Only Public API tokens are supported.
Schema
Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing.
Depending on your destination, table and column names may not appear as they are outlined below.
audit_events
The audit_events table contains the workspace audit trail, including user actions and configuration changes. Requires the Audit Trail feature (Business tier).
Replication Method | CDC |
Primary Key | id |
Replication Key | timestamp |
| Useful links |
catalog_destinations
The catalog_destinations table contains all available destination types from the Segment Destinations Catalog, across all workspaces.
Replication Method | Full Table |
Primary Key | id |
| Useful links |
catalog_sources
The catalog_sources table contains all available source types from the Segment Sources Catalog, across all workspaces.
Replication Method | Full Table |
Primary Key | id |
| Useful links |
catalog_warehouses
The catalog_warehouses table contains all available warehouse types from the Segment Warehouses Catalog, across all workspaces.
Replication Method | Full Table |
Primary Key | id |
| Useful links |
destination_delivery_metrics_summary
The destination_delivery_metrics_summary table contains delivery metrics for each source-to-destination pair in the workspace.
Replication Method | Full Table |
Primary Key | sourceId, destinationId |
| Useful links |
destination_subscriptions
The destination_subscriptions table contains event subscriptions configured per destination in the workspace.
Replication Method | Full Table |
Primary Key | id |
| Useful links |
destinations
The destinations table contains data destinations configured in the workspace.
Replication Method | Full Table |
Primary Key | id, sourceId |
| Useful links |
groups
The groups table contains user groups configured in the workspace.
Replication Method | Full Table |
Primary Key | id |
| Useful links |
source_connected_destinations
The source_connected_destinations table contains source-to-destination connections in the workspace.
Replication Method | Full Table |
Primary Key | id, sourceId |
| Useful links |
source_connected_warehouses
The source_connected_warehouses table contains source-to-warehouse connections in the workspace.
Replication Method | Full Table |
Primary Key | sourceId |
| Useful links |
sources
The sources table contains data sources configured in the workspace.
Replication Method | Full Table |
Primary Key | id |
| Useful links |
transformations
The transformations table contains data transformations configured in the workspace.
Replication Method | Full Table |
Primary Key | id |
| Useful links |
usage_api_calls_per_source_daily
The usage_api_calls_per_source_daily table contains daily API call usage broken down by source.
Replication Method | CDC |
Primary Key | sourceId |
Replication Key | timestamp |
| Useful links |
usage_api_calls_workspace_daily
The usage_api_calls_workspace_daily table contains daily total API call usage for the workspace.
Replication Method | CDC |
Primary Key | timestamp |
Replication Key | timestamp |
| Useful links |
usage_mtu_per_source_daily
The usage_mtu_per_source_daily table contains daily Monthly Tracked Users (MTU) usage broken down by source.
Replication Method | CDC |
Primary Key | sourceId |
Replication Key | timestamp |
| Useful links |
usage_mtu_workspace_daily
The usage_mtu_workspace_daily table contains daily total Monthly Tracked Users (MTU) usage for the workspace.
Replication Method | CDC |
Primary Key | timestamp |
Replication Key | timestamp |
| Useful links |
users
The users table contains users with access to the workspace.
Replication Method | Full Table |
Primary Key | id |
| Useful links |
warehouses
The warehouses table contains warehouse connections configured in the workspace.
Replication Method | Full Table |
Primary Key | id |
| Useful links |