Iceberg Table Catalog | NAGRAVISION Documentation Portal

Data Platform - Comprehensive table documentation for Apache Iceberg tables

Property	Value
Version	2.0.0
Last Updated	August 2026
Data Freshness	24 hours (Daily Batch)
Data Format	Apache Iceberg (Parquet + ZSTD)
Default Retention	TBC

Summary Overview

#	Table Name	Type	Mode	Primary Key	Grain	Retention
1	account_error_summary	Fact	MERGE	`date_day, accountid, deviceid, content_type, error_code, error_message`	One row per account/device/error combination per day	TBC
2	account_summary	Fact	MERGE	`date_day, accountid`	One row per account per day	TBC
3	account_summary_v2	Fact	MERGE	`date_day, accountid`	One row per account per day	TBC
4	accounts	Dimension	MERGE	`accountid`	One row per account	TBC
5	accountuserprofile	Dimension	APPEND	N/A	One row per user profile event	TBC
6	activities	Fact (Transformed)	APPEND	N/A	One row per enriched activity event	TBC
7	activity	Fact (Raw)	APPEND	N/A	One row per raw activity event	TBC
8	aggregated_channel	Dimension	MERGE	`editorialchannelid`	One row per channel	TBC
9	aggregated_editorialcontent	Dimension	MERGE	`editorialcontentid`	One row per content item	TBC
10	aggregated_event	Dimension	MERGE	`eventid`	One row per EPG event	TBC
11	channellocalizedattributes	Dimension	APPEND	N/A	One row per channel and locale	TBC
12	content_consumption	Fact	MERGE	`unique_id`	One row per content consumption session	TBC
13	device_summary	Fact	MERGE	`date_day, accountid, deviceid`	One row per device per day	TBC
14	devices	Dimension	MERGE	`accountid, deviceid`	One row per device per account	TBC
15	editorialcontentlocalizedattributes	Dimension	APPEND	N/A	One row per editorial content item and locale	TBC
16	eventlocalizedattributes	Dimension	APPEND	N/A	One row per event and locale	TBC
17	playback_metrics	Fact (Raw)	APPEND	N/A	One row per playback metric activity event	TBC
18	playback_session	Fact	MERGE	`session_unique_id`	One row per playback session	TBC
19	privacyactivity	Fact (Raw)	APPEND	N/A	One row per privacy consent/policy event	TBC
20	purchaseactivity	Fact (Raw)	APPEND	N/A	One row per purchase transaction event	TBC
21	subscriptions	Dimension	MERGE	`accountid, entitlementid`	One row per subscription per account	TBC

Detailed Table Definitions

account_error_summary

Fact · MERGE

Daily error aggregations per account, device, and error type. Used for error rate monitoring, troubleshooting, and quality analysis.

Property	Value
Primary Key	`date_day, accountid, deviceid, content_type, error_code, error_message`
Grain	One row per account/device/error combination per day
Bookmark Column	`ingestion_datetime`
Merge Lookback	72 hours
Retention	TBC
Column Count	24

#	Column Name	Type	PK	Description
1	`date_day`	`date`	Yes	Calendar date for which errors are aggregated, in local timezone (Primary Key)
2	`operatorid`	`string`		Tenant identifier
3	`unique_id`	`string`		Unique record identifier
4	`accountid`	`string`	Yes	Unique account identifier (Primary Key)
5	`account_number`	`string`		Account number for reference
6	`account_signon_id`	`string`		Account login identifier
7	`deviceid`	`string`	Yes	Device identifier (Primary Key)
8	`device_publicid`	`string`		Public-facing device identifier
9	`device_type`	`string`		Device category
10	`device_hardware_type`	`string`		Hardware type classification
11	`device_hardware_model`	`string`		Hardware model name
12	`device_hardware_manufacturer_name`	`string`		Device manufacturer name
13	`device_os_type`	`string`		Operating system type
14	`device_os_version`	`string`		Operating system version
15	`content_type`	`string`	Yes	Content type associated with the error (Primary Key)
16	`resource_type`	`string`		Resource type associated with the error
17	`error_code`	`string`	Yes	Error code identifying the type of error (Primary Key)
18	`error_message`	`string`	Yes	Error message describing the error (Primary Key)
19	`playererror_count`	`bigint`		Number of player errors for this combination on this day
20	`total_active_devices`	`bigint`		Total active devices on this day, used for error ratio calculation
21	`error_ratio`	`double`		Error rate relative to total active devices
22	`device_platform`	`string`		Platform classification combining device type and OS
23	`activity_raw_ingestion_datetime`	`timestamp`		Ingestion timestamp from the raw activity source
24	`ingestion_datetime`	`timestamp`		Timestamp when this record was last processed

account_summary

Fact · MERGE

Daily aggregated metrics per account including activity counts, playback events, recording statistics, and engagement metrics. This is the primary fact table for account-level analytics.

Property	Value
Primary Key	`date_day, accountid`
Grain	One row per account per day
Bookmark Column	`ingestion_datetime`
Merge Lookback	72 hours
Retention	TBC
Column Count	84

#	Column Name	Type	PK	Description
1	`date_day`	`date`	Yes	Calendar date for which all metrics are aggregated, in local timezone (Primary Key)
2	`operatorid`	`string`		Tenant identifier
3	`accountid`	`string`	Yes	Unique account identifier (Primary Key)
4	`account_number`	`string`		Account number for reference
5	`account_signon_id`	`string`		Account login identifier
6	`accountprofileid`	`string`		Account profile identifier
7	`corp`	`string`		Corporation/business unit identifier
8	`node`	`string`		Network node identifier
9	`connection_type`	`string`		Network connection type
10	`content_quality`	`string`		Content quality setting
11	`application_name`	`string`		Client application name
12	`application_version`	`string`		Client application version
13	`content_type`	`string`		Content type filter
14	`unique_connected_device_count`	`bigint`		Number of unique devices that connected to the account on this day
15	`lastlogindate_utc`	`timestamp`		Most recent login timestamp on this day
16	`total_login_count`	`bigint`		Total number of login events on this day
17	`watch_count`	`bigint`		Number of content viewing sessions initiated on this day
18	`watch_timestamp_utc`	`timestamp`		Most recent watch event timestamp on this day
19	`favorite_count`	`bigint`		Number of favorite actions on this day
20	`favorite_timestamp_utc`	`timestamp`		Most recent favorite event timestamp on this day
21	`playererror_count`	`bigint`		Number of video player errors encountered on this day
22	`playererror_timestamp_utc`	`timestamp`		Most recent player error timestamp on this day
23	`bookmark_count`	`bigint`		Number of playback position bookmarks created on this day
24	`bookmark_timestamp_utc`	`timestamp`		Most recent bookmark event timestamp on this day
25	`history_count`	`bigint`		Number of watch history entries created on this day
26	`history_timestamp_utc`	`timestamp`		Most recent history event timestamp on this day
27	`playlist_count`	`bigint`		Number of playlist modifications on this day
28	`playlist_timestamp_utc`	`timestamp`		Most recent playlist event timestamp on this day
29	`reminder_count`	`bigint`		Number of program reminders set on this day
30	`reminder_timestamp_utc`	`timestamp`		Most recent reminder event timestamp on this day
31	`playbackstart_count`	`bigint`		Number of playback sessions started on this day
32	`playbackstart_timestamp_utc`	`timestamp`		Most recent playback start timestamp on this day
33	`playbackstop_count`	`bigint`		Number of playback sessions stopped on this day
34	`playbackstop_timestamp_utc`	`timestamp`		Most recent playback stop timestamp on this day
35	`appstart_count`	`bigint`		Number of application launches on this day
36	`appstart_timestamp_utc`	`timestamp`		Most recent app start timestamp on this day
37	`append_count`	`bigint`		Number of application close events on this day
38	`append_timestamp_utc`	`timestamp`		Most recent app close event timestamp on this day
39	`playbackpause_count`	`bigint`		Number of playback pause events on this day
40	`playbackpause_timestamp_utc`	`timestamp`		Most recent playback pause timestamp on this day
41	`playbackskipahead_count`	`bigint`		Number of forward seek/skip operations on this day
42	`playbackskipahead_timestamp_utc`	`timestamp`		Most recent skip ahead timestamp on this day
43	`playbackskipback_count`	`bigint`		Number of backward seek/rewind operations on this day
44	`playbackskipback_timestamp_utc`	`timestamp`		Most recent skip back timestamp on this day
45	`adwatched_count`	`bigint`		Number of advertisements viewed to completion on this day
46	`adwatched_timestamp_utc`	`timestamp`		Most recent ad watched timestamp on this day
47	`addelivered_count`	`bigint`		Number of advertisements delivered on this day
48	`addelivered_timestamp_utc`	`timestamp`		Most recent ad delivered timestamp on this day
49	`adskipped_count`	`bigint`		Number of advertisements skipped on this day
50	`adskipped_timestamp_utc`	`timestamp`		Most recent ad skipped timestamp on this day
51	`schedulerecording_count`	`bigint`		Number of recordings scheduled on this day
52	`schedulerecording_timestamp_utc`	`timestamp`		Most recent schedule recording timestamp on this day
53	`playbackheartbeat_count`	`bigint`		Number of periodic playback heartbeat events on this day
54	`playbackheartbeat_timestamp_utc`	`timestamp`		Most recent playback heartbeat timestamp on this day
55	`genericerror_count`	`bigint`		Number of generic application errors on this day
56	`genericerror_timestamp_utc`	`timestamp`		Most recent generic error timestamp on this day
57	`thirdpartyappstart_count`	`bigint`		Number of third-party application launches on this day
58	`thirdpartyappstart_timestamp_utc`	`timestamp`		Most recent third-party app start timestamp on this day
59	`returntolauncher_count`	`bigint`		Number of return-to-home-screen events on this day
60	`returntolauncher_timestamp_utc`	`timestamp`		Most recent return to launcher timestamp on this day
61	`deeplinktriggered_count`	`bigint`		Number of deep link navigation events on this day
62	`deeplinktriggered_timestamp_utc`	`timestamp`		Most recent deep link triggered timestamp on this day
63	`downloadtriggered_count`	`bigint`		Number of content downloads initiated on this day
64	`downloadtriggered_timestamp_utc`	`timestamp`		Most recent download triggered timestamp on this day
65	`railview_count`	`bigint`		Number of content rail/carousel view events on this day
66	`railview_timestamp_utc`	`timestamp`		Most recent rail view timestamp on this day
67	`railselection_count`	`bigint`		Number of content rail/carousel selection events on this day
68	`railselection_timestamp_utc`	`timestamp`		Most recent rail selection timestamp on this day
69	`total_activity_count`	`bigint`		Total count of all activity events for the account on this day
70	`activity_datetime_utc`	`timestamp`		Most recent activity event timestamp across all types on this day
71	`playback_metrics_count`	`bigint`		Number of playback quality metric events on this day
72	`playback_metrics_timestamp_utc`	`timestamp`		Most recent playback metrics timestamp on this day
73	`recording_total_capture_duration`	`bigint`		Total duration of all completed recordings in seconds
74	`recording_new_count`	`bigint`		Number of newly scheduled recordings
75	`recording_failed_count`	`bigint`		Number of recordings that failed to complete
76	`recording_recorded_count`	`bigint`		Number of successfully completed recordings
77	`recording_total_count`	`bigint`		Total number of all recordings regardless of status
78	`recording_timestamp_utc`	`timestamp`		Most recent recording event timestamp
79	`private_recording_count`	`bigint`		Number of private/personal DVR recordings
80	`event_recording_count`	`bigint`		Number of network/event recordings
81	`recording_deletedby_system_count`	`bigint`		Number of recordings auto-deleted by system for quota management
82	`recording_deletedby_user_count`	`bigint`		Number of recordings manually deleted by user
83	`scheduled_recording_count`	`bigint`		Number of rescheduled recordings
84	`ingestion_datetime`	`timestamp`		Timestamp when this record was last processed

account_summary_v2

Fact · MERGE

Daily aggregated account-level metrics including logins, activity engagement, playback metric counts, recording statistics, and account identifiers.

Property	Value
Primary Key	`date_day, accountid`
Grain	One row per account per day
Bookmark Column	`ingestion_datetime`
Merge Lookback	72 hours
Retention	TBC
Column Count	77

#	Column Name	Type	PK	Description
1	`date_day`	`date`	Yes	Calendar date for account-level aggregation in local timezone (Primary Key)
2	`operatorid`	`string`		Tenant identifier
3	`accountid`	`string`	Yes	Unique account identifier (Primary Key)
4	`unique_connected_device_count`	`bigint`		Number of unique devices connected to the account on this day
5	`lastlogindate_utc`	`timestamp`		Most recent login timestamp on this day
6	`total_login_count`	`bigint`		Total number of login events on this day
7	`watch_count`	`bigint`		Number of watch events on this day
8	`watch_timestamp_utc`	`timestamp`		Most recent watch event timestamp on this day
9	`favorite_count`	`bigint`		Number of favorite actions on this day
10	`favorite_timestamp_utc`	`timestamp`		Most recent favorite event timestamp on this day
11	`playererror_count`	`bigint`		Number of video player errors on this day
12	`playererror_timestamp_utc`	`timestamp`		Most recent player error timestamp on this day
13	`bookmark_count`	`bigint`		Number of bookmark actions on this day
14	`bookmark_timestamp_utc`	`timestamp`		Most recent bookmark event timestamp on this day
15	`history_count`	`bigint`		Number of history actions on this day
16	`history_timestamp_utc`	`timestamp`		Most recent history event timestamp on this day
17	`playlist_count`	`bigint`		Number of playlist actions on this day
18	`playlist_timestamp_utc`	`timestamp`		Most recent playlist event timestamp on this day
19	`reminder_count`	`bigint`		Number of reminder actions on this day
20	`reminder_timestamp_utc`	`timestamp`		Most recent reminder event timestamp on this day
21	`playbackstart_count`	`bigint`		Number of playback starts on this day
22	`playbackstart_timestamp_utc`	`timestamp`		Most recent playback start timestamp on this day
23	`playbackstop_count`	`bigint`		Number of playback stops on this day
24	`playbackstop_timestamp_utc`	`timestamp`		Most recent playback stop timestamp on this day
25	`appstart_count`	`bigint`		Number of application starts on this day
26	`appstart_timestamp_utc`	`timestamp`		Most recent application start timestamp on this day
27	`append_count`	`bigint`		Number of application end events on this day
28	`append_timestamp_utc`	`timestamp`		Most recent application end timestamp on this day
29	`playbackpause_count`	`bigint`		Number of playback pause events on this day
30	`playbackpause_timestamp_utc`	`timestamp`		Most recent playback pause timestamp on this day
31	`playbackskipahead_count`	`bigint`		Number of skip-ahead events on this day
32	`playbackskipahead_timestamp_utc`	`timestamp`		Most recent skip-ahead timestamp on this day
33	`playbackskipback_count`	`bigint`		Number of skip-back events on this day
34	`playbackskipback_timestamp_utc`	`timestamp`		Most recent skip-back timestamp on this day
35	`adwatched_count`	`bigint`		Number of ads watched on this day
36	`adwatched_timestamp_utc`	`timestamp`		Most recent ad watched timestamp on this day
37	`addelivered_count`	`bigint`		Number of ads delivered on this day
38	`addelivered_timestamp_utc`	`timestamp`		Most recent ad delivered timestamp on this day
39	`adskipped_count`	`bigint`		Number of ads skipped on this day
40	`adskipped_timestamp_utc`	`timestamp`		Most recent ad skipped timestamp on this day
41	`schedulerecording_count`	`bigint`		Number of schedule recording events on this day
42	`schedulerecording_timestamp_utc`	`timestamp`		Most recent schedule recording timestamp on this day
43	`playbackheartbeat_count`	`bigint`		Number of playback heartbeat events on this day
44	`playbackheartbeat_timestamp_utc`	`timestamp`		Most recent playback heartbeat timestamp on this day
45	`genericerror_count`	`bigint`		Number of generic error events on this day
46	`genericerror_timestamp_utc`	`timestamp`		Most recent generic error timestamp on this day
47	`thirdpartyappstart_count`	`bigint`		Number of third-party app starts on this day
48	`thirdpartyappstart_timestamp_utc`	`timestamp`		Most recent third-party app start timestamp on this day
49	`returntolauncher_count`	`bigint`		Number of return-to-launcher events on this day
50	`returntolauncher_timestamp_utc`	`timestamp`		Most recent return-to-launcher timestamp on this day
51	`deeplinktriggered_count`	`bigint`		Number of deep link triggered events on this day
52	`deeplinktriggered_timestamp_utc`	`timestamp`		Most recent deep link triggered timestamp on this day
53	`downloadtriggered_count`	`bigint`		Number of download triggered events on this day
54	`downloadtriggered_timestamp_utc`	`timestamp`		Most recent download triggered timestamp on this day
55	`railview_count`	`bigint`		Number of rail view events on this day
56	`railview_timestamp_utc`	`timestamp`		Most recent rail view timestamp on this day
57	`railselection_count`	`bigint`		Number of rail selection events on this day
58	`railselection_timestamp_utc`	`timestamp`		Most recent rail selection timestamp on this day
59	`total_activity_count`	`bigint`		Total activity event count on this day
60	`activity_datetime_utc`	`timestamp`		Most recent activity timestamp on this day
61	`playback_metrics_count`	`bigint`		Number of playback metric events on this day
62	`playback_metrics_timestamp_utc`	`timestamp`		Most recent playback metrics timestamp on this day
63	`recording_total_capture_duration`	`bigint`		Total completed recording duration in seconds
64	`recording_new_count`	`bigint`		Number of new recordings
65	`recording_failed_count`	`bigint`		Number of failed recordings
66	`recording_recorded_count`	`bigint`		Number of recorded recordings
67	`recording_total_count`	`bigint`		Total number of recordings
68	`recording_timestamp_utc`	`timestamp`		Most recent recording timestamp
69	`private_recording_count`	`bigint`		Number of private recordings
70	`event_recording_count`	`bigint`		Number of event recordings
71	`recording_deletedby_system_count`	`bigint`		Number of recordings deleted by system
72	`recording_deletedby_user_count`	`bigint`		Number of recordings deleted by user
73	`scheduled_recording_count`	`bigint`		Number of rescheduled recordings
74	`account_number`	`string`		Account number for reference
75	`account_signon_id`	`string`		Account login identifier
76	`accountprofileid`	`string`		Account profile identifier
77	`ingestion_datetime`	`timestamp`		Timestamp when this record was last processed

accounts

Dimension · MERGE

Master data table containing account information including profile details, status, contact information, and billing attributes. This is the primary dimension table for customer account data.

Property	Value
Primary Key	`accountid`
Grain	One row per account
Bookmark Column	`ingestion_datetime`
Merge Lookback	72 hours
Retention	TBC
Column Count	40

#	Column Name	Type	PK	Description
1	`operatorid`	`string`		Unique tenant identifier
2	`date_day`	`date`		Date portion of the account creation timestamp, converted to the local timezone
3	`accountid`	`string`	Yes	Primary key - Unique account identifier
4	`created_at_utc`	`timestamp`		UTC timestamp when the account was first created/registered
5	`updated_at_utc`	`timestamp`		UTC timestamp of the most recent account profile update
6	`account_number`	`string`		Account number used for billing/support reference
7	`pvr_status`	`string`		Local PVR/DVR feature status
8	`npvr_profile_name`	`string`		Cloud/Network PVR storage profile name that determines the recording quota tier
9	`status`	`string`		Account lifecycle status (e.g., ACTIVE, SUSPENDED, CANCELLED)
10	`credit_spent`	`double`		Cumulative credit/prepaid balance spent on the account
11	`account_profile`	`string`		Account profile identifier
12	`external_id`	`string`		External system identifier for cross-system integration
13	`validity_period_start_date_utc`	`timestamp`		UTC start date of the account validity period
14	`validity_period_end_date_utc`	`timestamp`		UTC end date of the account validity period
15	`home_ipaddress`	`string`		Registered home network IP address
16	`signon_id`	`string`		User login identifier for authentication
17	`geo_block_exempt`	`boolean`		Whether the account is exempt from geographic content restrictions
18	`npvr_quota`	`bigint`		Cloud PVR storage quota allocated to the account
19	`address_first_name`	`string`		Account holder's first name
20	`address_last_name`	`string`		Account holder's last name
21	`address_line1`	`string`		Primary street address line
22	`address_line2`	`string`		Secondary address line (apartment, suite, unit)
23	`address_line3`	`string`		Additional address information
24	`post_zipcode`	`string`		Postal/ZIP code for the service address
25	`address_type_value`	`string`		Address classification (e.g., HOME, BILLING)
26	`address_nick_name`	`string`		User-defined friendly name for the address
27	`address_date_of_birth`	`timestamp`		Account holder's date of birth for age verification
28	`address_homephone`	`string`		Home phone number
29	`address_mobile`	`string`		Mobile phone number
30	`address_middle_name`	`string`		Account holder's middle name
31	`address_external_system_id`	`string`		Address identifier from external address validation system
32	`destination_network_id`	`string`		Network ID for content delivery routing
33	`gender`	`string`		Account holder's gender
34	`sso`	`string`		Single Sign-On identifier
35	`optin`	`string`		Marketing communication opt-in status
36	`last_logindate_utc`	`timestamp`		Most recent login timestamp in UTC
37	`billing_address_country_code`	`string`		ISO country code from billing address
38	`last_login_date`	`date`		Date portion of the last login timestamp, converted to local timezone
39	`is_opf`	`boolean`		Data source indicator flag
40	`ingestion_datetime`	`timestamp`		Timestamp when this record was last processed

accountuserprofile

Dimension · APPEND

User profile information linked to accounts, including profile names, default/child profile indicators, and age ratings for parental controls.

Property	Value
Primary Key	`N/A`
Grain	One row per user profile event
Bookmark Column	`ingestion_datetime`
Retention	TBC
Column Count	10

#	Column Name	Type	Description
1	`operatorid`	`string`	Tenant identifier
2	`accountid`	`string`	Parent account identifier
3	`profileid`	`string`	Unique profile identifier
4	`name`	`string`	Profile display name
5	`defaultprofile`	`string`	Whether this is the default profile
6	`childprofile`	`string`	Whether this is a child/kids profile
7	`agerating`	`string`	Maximum allowed content age rating
8	`createddatetime`	`timestamp`	UTC timestamp when profile was created
9	`modifieddatetime`	`timestamp`	UTC timestamp of last profile modification
10	`ingestion_datetime`	`timestamp`	Data ingestion timestamp

activities

Fact (Transformed) · APPEND

Enriched activity events table combining raw activity data with content metadata from editorial channels, events, and content groups. Includes denormalized channel names, event titles, and content details for simplified analytics queries.

Property	Value
Primary Key	`N/A`
Grain	One row per enriched activity event
Bookmark Column	`ingestion_datetime`
Retention	TBC
Column Count	96

#	Column Name	Type	Description
1	`operatorid`	`string`	Tenant identifier
2	`date_day`	`date`	Date of the activity event in local timezone
3	`accountid`	`string`	Account identifier
4	`account_number`	`string`	Account number for reference
5	`account_signon_id`	`string`	Account login identifier
6	`deviceid`	`string`	Device identifier
7	`device_publicid`	`string`	Public-facing device identifier
8	`device_type`	`string`	Device category
9	`device_casn`	`string`	Device conditional access serial number
10	`device_hardware_type`	`string`	Hardware type classification
11	`device_hardware_model`	`string`	Hardware model name
12	`device_hardware_manufacturer_name`	`string`	Device manufacturer name
13	`device_os_type`	`string`	Operating system type
14	`device_os_version`	`string`	Operating system version
15	`activityid`	`bigint`	Unique activity event identifier
16	`activity_type`	`string`	Category of activity (Activity, Bookmark, Favorite, Playlist, Reminder, History)
17	`name`	`string`	Activity event name
18	`value`	`string`	Activity event value
19	`created_at_utc`	`timestamp`	UTC timestamp when the activity event was created
20	`updated_at_utc`	`timestamp`	UTC timestamp of the most recent activity event update
21	`programme_id`	`string`	Programme identifier
22	`channel_id`	`string`	Channel identifier
23	`playlist_id`	`string`	Playlist identifier
24	`user_id`	`string`	User identifier
25	`channel`	`string`	Channel name or reference
26	`activity_device_type`	`string`	Device type from the activity event
27	`tags`	`string`	Activity event tags
28	`position`	`int`	Playback position in seconds
29	`favourite_list_id`	`string`	Favourite list identifier
30	`categories`	`string`	Content categories
31	`content_id`	`string`	Resolved content identifier
32	`content_type`	`string`	Content type classification (live, vod, recording)
33	`recording_id`	`string`	Recording identifier
34	`activity_metadata_id`	`string`	Activity metadata identifier
35	`template_id`	`string`	Template identifier
36	`rail_id`	`string`	UI rail/row identifier
37	`depth`	`int`	Navigation depth level
38	`deeplink_provider_id`	`string`	Deeplink provider identifier
39	`provider_resource_id`	`string`	Provider resource identifier
40	`source`	`string`	Source of the activity event
41	`app_name`	`string`	Client application name
42	`app_reference`	`string`	Application reference
43	`error_code`	`string`	Error code if applicable
44	`error_msg`	`string`	Error message if applicable
45	`player_type_version`	`string`	Player type and version
46	`playback_session_id`	`string`	Playback session identifier
47	`series_link`	`string`	Series link identifier
48	`ad_supplier`	`string`	Ad supplier identifier
49	`tracking_asset_id`	`string`	Tracking asset identifier
50	`ad_id`	`string`	Ad identifier
51	`start_position`	`int`	Playback start position in seconds
52	`stop_position`	`int`	Playback stop position in seconds
53	`app_session_id`	`string`	Application session identifier
54	`section_id`	`string`	Section identifier
55	`series_id`	`string`	Series identifier
56	`content_source`	`string`	Content source
57	`activity_datetime_utc`	`timestamp`	Activity event datetime in UTC
58	`playout_url`	`string`	Playout URL
59	`sdk_version`	`string`	SDK version
60	`app_version`	`string`	Application version
61	`client_page_or_screen`	`string`	Client page or screen name
62	`userprofileid`	`string`	User profile identifier
63	`eventid`	`string`	Event identifier
64	`event_name`	`string`	Event name
65	`event_start`	`timestamp`	Event start timestamp
66	`event_end`	`timestamp`	Event end timestamp
67	`event_locale`	`string`	Event locale
68	`event_title`	`string`	Event title
69	`event_genre`	`string`	Event genre
70	`event_updated_at`	`timestamp`	Event last update timestamp
71	`editorialchannelid`	`string`	Editorial channel identifier
72	`channel_name`	`string`	Channel name
73	`channel_locale`	`string`	Channel locale
74	`channel_updated_at`	`timestamp`	Channel last update timestamp
75	`editorialcontentid`	`string`	Editorial content identifier
76	`editorialcontent_content_type`	`string`	Editorial content type
77	`editorialcontent_name`	`string`	Editorial content name
78	`editorialcontent_title`	`string`	Editorial content title
79	`editorialcontent_contentduration_in_sec`	`bigint`	Editorial content duration in seconds
80	`editorialcontent_locale`	`string`	Editorial content locale
81	`editorialcontent_updated_at`	`timestamp`	Editorial content last update timestamp
82	`season_number`	`int`	Season number
83	`episode_number`	`int`	Episode number
84	`editorialcontent_genre`	`string`	Editorial content genre
85	`contentgroupid`	`string`	Content group identifier
86	`contentgroup_content_type`	`string`	Content group content type
87	`contentgroup_name`	`string`	Content group name
88	`contentgroup_locale`	`string`	Content group locale
89	`contentgroup_updated_at`	`timestamp`	Content group last update timestamp
90	`viewer_location`	`string`	Viewer location
91	`strength`	`double`	Signal strength
92	`quality`	`int`	Signal quality
93	`bit_rate_error_ratio`	`int`	Bit rate error ratio
94	`signal_to_noise_ratio`	`double`	Signal to noise ratio
95	`lock`	`boolean`	Signal lock status
96	`ingestion_datetime`	`timestamp`	Timestamp when this record was last processed

activity

Fact (Raw) · APPEND

Raw activity events table capturing all user interactions including playback events, favorites, bookmarks, errors, and application usage. This is an append-only table preserving full event history.

Property	Value
Primary Key	`N/A`
Grain	One row per raw activity event
Bookmark Column	`ingestion_datetime`
Retention	TBC
Column Count	64

#	Column Name	Type	Description
1	`operatorid`	`string`	Tenant identifier
2	`activityid`	`bigint`	Unique activity event identifier
3	`activity_id`	`string`	External activity identifier (UUID)
4	`accountid`	`string`	Account identifier
5	`activitytypeid`	`int`	Numeric code for activity category
6	`name`	`string`	Activity event name
7	`value`	`string`	Activity-specific payload value
8	`createddatetime`	`timestamp`	UTC timestamp when the activity was created
9	`modifieddatetime`	`timestamp`	UTC timestamp of last modification
10	`programmeid`	`string`	Legacy programme identifier
11	`channelid`	`string`	Channel identifier
12	`playlistid`	`string`	Playlist identifier
13	`userid`	`string`	User profile identifier
14	`deviceid`	`string`	Device identifier
15	`channel`	`string`	Channel name
16	`devicetype`	`string`	Device type classification
17	`tags`	`string`	Activity tags/labels
18	`position`	`int`	Playback position in seconds
19	`favouritelistid`	`string`	Favorites list identifier
20	`categories`	`string`	Content categories
21	`editorialcontentid`	`string`	Editorial content identifier
22	`editorialchannelid`	`string`	Editorial channel identifier
23	`eventid`	`string`	EPG event identifier
24	`contentgroupid`	`string`	Content group/series identifier
25	`contenttype`	`string`	Content type
26	`recordingid`	`string`	Recording identifier
27	`activitymetadataid`	`string`	Activity metadata reference
28	`templateid`	`string`	UI template identifier
29	`railid`	`string`	Content rail identifier
30	`depth`	`int`	Navigation depth level
31	`deeplinkproviderid`	`string`	Deep link provider identifier
32	`providerresourceid`	`string`	Provider's content resource reference
33	`source`	`string`	Data source origin
34	`appname`	`string`	Application name
35	`appreference`	`string`	Application reference
36	`errorcode`	`string`	Error code
37	`errormsg`	`string`	Error message
38	`playertypeversion`	`string`	Video player type and version
39	`playbacksessionid`	`string`	Playback session identifier
40	`serieslink`	`string`	Series linking identifier
41	`adsupplier`	`string`	Ad supplier identifier
42	`trackingassetid`	`string`	Tracking asset identifier
43	`adid`	`string`	Advertisement identifier
44	`startposition`	`int`	Playback start position
45	`stopposition`	`int`	Playback stop position
46	`appsessionid`	`string`	Application session identifier
47	`sectionid`	`string`	UI section identifier
48	`seriesid`	`string`	TV series identifier
49	`contentsource`	`string`	Content delivery source
50	`activitydatetime`	`timestamp`	Activity timestamp
51	`editorialid`	`string`	Editorial content identifier
52	`userprofileid`	`string`	User profile identifier
53	`activitytype`	`string`	Activity type name
54	`playouturl`	`string`	Content playout URL
55	`sdkversion`	`string`	SDK version
56	`appversion`	`string`	Application version
57	`clientpageorscreen`	`string`	UI page/screen name
58	`viewer_location`	`string`	Viewer geographic location
59	`strength`	`double`	Signal strength
60	`quality`	`int`	Signal quality
61	`bitrateerrorratio`	`int`	Bit error rate
62	`signaltonoiseratio`	`double`	Signal-to-noise ratio
63	`lock`	`boolean`	Signal lock status
64	`ingestion_datetime`	`timestamp`	Data ingestion timestamp

aggregated_channel

Dimension · MERGE

Channel metadata dimension table including channel names, definitions, categories, and time-shifting capabilities (catchup, startover, network PVR).

Property	Value
Primary Key	`editorialchannelid`
Grain	One row per channel
Bookmark Column	`ingestion_datetime`
Retention	TBC
Column Count	29

#	Column Name	Type	PK	Description
1	`operatorid`	`string`		Tenant identifier
2	`editorialchannelid`	`string`	Yes	Primary key - Unique channel identifier
3	`providerid`	`string`		Content provider identifier
4	`providerresourceid`	`string`		Provider's resource identifier
5	`name`	`string`		Channel display name
6	`definition`	`string`		Video quality definition
7	`shortname`	`string`		Abbreviated channel name
8	`categories`	`string`		Channel genre/category
9	`created_at`	`timestamp`		Channel record creation timestamp
10	`updated_at`	`timestamp`		Last update timestamp
11	`isdeleted`	`boolean`		Soft delete flag
12	`rating`	`string`		Parental rating classification
13	`guardtimestart`	`string`		Recording buffer time before program start
14	`guardtimeend`	`string`		Recording buffer time after program end
15	`timeshifting_longtermcatchupparameters_eventdefaultflag`	`boolean`		Default flag for long-term catchup
16	`timeshifting_longtermcatchupsupport`	`boolean`		Long-term catchup support flag
17	`timeshifting_networkpvrparameters_eventdefaultflag`	`boolean`		Default flag for network PVR
18	`timeshifting_networkpvrsupport`	`boolean`		Network PVR support flag
19	`timeshifting_shorttermcatchupparameters_eventdefaultflag`	`boolean`		Default flag for short-term catchup
20	`timeshifting_shorttermcatchupsupport`	`boolean`		Short-term catchup support flag
21	`timeshifting_startoverparameters_eventdefaultflag`	`boolean`		Default flag for start-over
22	`timeshifting_startoversupport`	`boolean`		Start-over support flag
23	`channelnumber`	`int`		Logical channel number
24	`channelid`	`string`		Technical channel identifier
25	`locale`	`string`		Language/locale code
26	`title`	`string`		Localized channel title
27	`longname`	`string`		Full channel name
28	`metadata_categories`	`string`		Additional category metadata
29	`ingestion_datetime`	`timestamp`		Data ingestion timestamp

aggregated_editorialcontent

Dimension · MERGE

Content metadata dimension table including titles, descriptions, categories, series/season information, ratings, and content duration.

Property	Value
Primary Key	`editorialcontentid`
Grain	One row per content item
Bookmark Column	`ingestion_datetime`
Retention	TBC
Column Count	40

#	Column Name	Type	PK	Description
1	`operatorid`	`string`		Tenant identifier
2	`editorialcontentid`	`string`	Yes	Primary key - Unique content identifier
3	`contenttype`	`string`		Content type classification
4	`providerid`	`string`		Content provider identifier
5	`providerresourceid`	`string`		Provider's resource identifier
6	`name`	`string`		Content display name
7	`aspect`	`string`		Video aspect ratio
8	`definition`	`string`		Video quality definition
9	`audiomode`	`string`		Audio format
10	`isrecordable`	`boolean`		Whether content can be recorded
11	`year`	`int`		Production/release year
12	`countries`	`string`		Countries of production
13	`categories`	`string`		Genre/category classifications
14	`seasonnumber`	`int`		Season number
15	`created_at`	`timestamp`		Content creation timestamp
16	`updated_at`	`timestamp`		Last update timestamp
17	`contentgroupid`	`string`		Content group identifier
18	`subtitles`	`string`		Available subtitle languages
19	`isdeleted`	`boolean`		Soft delete flag
20	`rating`	`string`		Parental rating
21	`episodenumber`	`int`		Episode number
22	`seasonrefid`	`string`		Parent season reference
23	`seriesrefid`	`string`		Parent series reference
24	`content_start`	`timestamp`		Content availability start time
25	`content_end`	`timestamp`		Content availability end time
26	`contentduration`	`bigint`		Content duration in seconds
27	`scope`	`string`		Content availability scope
28	`locale`	`string`		Language/locale code
29	`title`	`string`		Localized content title
30	`synopsis`	`string`		Short content synopsis
31	`description`	`string`		Full content description
32	`episodetitle`	`string`		Episode title
33	`actors`	`string`		Cast list
34	`shorttitle`	`string`		Abbreviated title
35	`genre`	`string`		Primary genre
36	`directors`	`string`		Director(s)
37	`metadata_categories`	`string`		Additional category metadata
38	`duration`	`int`		Runtime duration in seconds
39	`netduration`	`int`		Net content duration in seconds
40	`ingestion_datetime`	`timestamp`		Data ingestion timestamp

aggregated_event

Dimension · MERGE

EPG event metadata dimension table including event titles, start/end times, channel associations, and time-shifting support flags.

Property	Value
Primary Key	`eventid`
Grain	One row per EPG event
Bookmark Column	`ingestion_datetime`
Retention	TBC
Column Count	31

#	Column Name	Type	PK	Description
1	`operatorid`	`string`		Tenant identifier
2	`eventid`	`string`	Yes	Primary key - Unique EPG event identifier
3	`providerid`	`string`		EPG metadata provider identifier
4	`providerresourceid`	`string`		Provider's resource identifier
5	`name`	`string`		Program/event name
6	`channelid`	`string`		Channel broadcasting this event
7	`isdeleted`	`boolean`		Soft delete flag
8	`editorialcontentid`	`string`		Associated content metadata identifier
9	`tmsid`	`string`		External program matching identifier
10	`seasonnumber`	`int`		Season number
11	`scoring`	`double`		Relevance/popularity score
12	`countries`	`string`		Countries of origin
13	`year`	`int`		Production year
14	`categories`	`string`		Genre/category classifications
15	`created_at`	`timestamp`		Event creation timestamp
16	`updated_at`	`timestamp`		Last update timestamp
17	`rating`	`string`		Parental rating
18	`event_start`	`timestamp`		Broadcast start time
19	`event_end`	`timestamp`		Broadcast end time
20	`episodenumber`	`int`		Episode number
21	`longtermcatchupsupport`	`boolean`		Long-term catchup support
22	`networkpvrsupport`	`boolean`		Network PVR support
23	`shorttermcatchupsupport`	`boolean`		Short-term catchup support
24	`startoversupport`	`boolean`		Start-over support
25	`locale`	`string`		Language/locale code
26	`title`	`string`		Localized event title
27	`episode`	`string`		Episode title
28	`genre`	`string`		Primary genre
29	`metadata_categories`	`string`		Additional category metadata
30	`ispurged`	`boolean`		Purge status flag
31	`ingestion_datetime`	`timestamp`		Data ingestion timestamp

channellocalizedattributes

Dimension · APPEND

Localized channel attributes including titles, long names, and category labels by locale.

Property	Value
Primary Key	`N/A`
Grain	One row per channel and locale
Bookmark Column	`ingestion_datetime`
Retention	TBC
Column Count	7

#	Column Name	Type	Description
1	`operatorid`	`string`	Tenant identifier
2	`channelid`	`string`	Channel identifier
3	`locale`	`string`	Locale code
4	`title`	`string`	Localized channel title
5	`longname`	`string`	Localized long channel name
6	`categories`	`string`	Localized channel categories
7	`ingestion_datetime`	`timestamp`	Data ingestion timestamp

content_consumption

Fact · MERGE

Content consumption events tracking what content was consumed, when, and by whom. Includes content identifiers, consumption duration, quality metrics, and viewing session details.

Property	Value
Primary Key	`unique_id`
Grain	One row per content consumption session
Bookmark Column	`ingestion_datetime`
Retention	TBC
Column Count	99

#	Column Name	Type	PK	Description
1	`date_day`	`date`		Date of the content consumption event in local timezone
2	`accountid`	`string`		Account identifier
3	`app_session_id`	`string`		Application session identifier
4	`playback_session_id`	`string`		Playback session identifier
5	`account_number`	`string`		Account number for reference
6	`account_signon_id`	`string`		Account login identifier
7	`deviceid`	`string`		Device identifier
8	`device_publicid`	`string`		Public-facing device identifier
9	`content_type`	`string`		Content type classification (live, vod, recording)
10	`resource_type`	`string`		Original resource type from the activity event
11	`content_id`	`string`		Resolved content identifier
12	`channel_id`	`string`		Channel identifier
13	`channel_number`	`int`		Channel number
14	`event_id`	`string`		Event identifier
15	`channel_name`	`string`		Channel name
16	`channel_title`	`string`		Channel title
17	`event_name`	`string`		Event name
18	`event_title`	`string`		Event title
19	`vod_title`	`string`		VOD content title
20	`content_name`	`string`		Content name
21	`event_genre`	`string`		Event genre
22	`vod_genre`	`string`		VOD content genre
23	`season_number`	`int`		Season number
24	`episode_number`	`int`		Episode number
25	`contentgroup_name`	`string`		Content group name
26	`genre`	`string`		Content genre
27	`event_locale`	`string`		Event locale
28	`locale`	`string`		Content locale
29	`corp`	`string`		Corporate/organization identifier
30	`node`	`string`		Network node identifier
31	`connection_type`	`string`		Connection type
32	`content_quality`	`string`		Content quality classification
33	`application_name`	`string`		Client application name
34	`application_version`	`string`		Client application version
35	`device_hardware_type`	`string`		Hardware type classification
36	`device_hardware_manufacturer_name`	`string`		Device manufacturer name
37	`device_hardware_model`	`string`		Hardware model name
38	`device_hardware_model_major_version`	`string`		Hardware model major version
39	`device_platform`	`string`		Device platform
40	`device_os_type`	`string`		Operating system type
41	`device_os_version`	`string`		Operating system version
42	`device_type`	`string`		Device category
43	`playback_start_time_utc`	`timestamp`		UTC timestamp when playback started
44	`playback_end_time_utc`	`timestamp`		UTC timestamp when playback ended
45	`playback_session_duration_in_secs`	`int`		Total session duration in seconds
46	`played_duration_in_secs`	`int`		Actual playback duration in seconds
47	`total_viewing_seconds`	`int`		Total viewing time in seconds
48	`completion_percent`	`float`		Percentage of content consumed
49	`offset_from_start`	`int`		Offset from content start in seconds
50	`offset_from_end`	`int`		Offset from content end in seconds
51	`valid`	`boolean`		Whether the session is valid
52	`invalid_session`	`boolean`		Whether the session is invalid
53	`total_buffering_seconds`	`decimal`		Total time spent buffering in seconds
54	`buffering_ratio`	`float`		Ratio of buffering time to session duration
55	`avg_framedrops`	`float`		Average frame drops during the session
56	`sum_framedrops`	`float`		Total number of frame drops during the session
57	`frame_drops_per_min`	`float`		Frame drops per minute of playback
58	`total_videoframes`	`int`		Total number of video frames rendered
59	`sum_bytes_downloaded`	`int`		Total bytes downloaded during the session
60	`avg_download_bitrate`	`int`		Average download bitrate during the session
61	`avg_selected_bitrate`	`decimal`		Average selected video bitrate during the session
62	`sum_bitrate_switches`	`bigint`		Total number of bitrate switches
63	`count_bitrate_downgrades`	`bigint`		Number of bitrate downgrade events
64	`avg_stream_bitrate`	`int`		Average stream bitrate during the session
65	`sum_bitrate_downgrades`	`bigint`		Sum of bitrate downgrade events
66	`avg_bitrate`	`float`		Average bitrate during the session
67	`max_available_bitrates`	`string`		Maximum available bitrates for the stream
68	`bitrates`	`string`		Bitrate values during the session
69	`count_stalled_events`	`bigint`		Number of stalled events during the session
70	`count_bitrate_switch_events`	`bigint`		Number of bitrate switch events
71	`count_error_events`	`bigint`		Number of error events during the session
72	`count_time_to_video_start_events`	`bigint`		Number of time-to-video-start events
73	`total_time_to_video_start`	`decimal`		Total time to video start in seconds
74	`avg_time_to_start`	`float`		Average time to video start in seconds
75	`buffering_rate`	`float`		Buffering event rate
76	`buffering_rate_per_min`	`float`		Buffering event rate per minute
77	`content_duration_in_secs`	`int`		Content duration in seconds
78	`event_start_time`	`timestamp`		Event start timestamp
79	`event_end_time`	`timestamp`		Event end timestamp
80	`vod_content_duration_in_secs`	`int`		VOD content duration in seconds
81	`session_qoe`	`double`		Session Quality of Experience score
82	`completion_mintues`	`int`		Completion time in minutes
83	`device_id`	`string`		Device identifier
84	`first_metrics_buffering_seconds`	`decimal`		Initial buffering seconds at session start
85	`first_metrics_viewing_seconds`	`decimal`		Initial viewing seconds at session start
86	`ingestion_datetime`	`timestamp`		Timestamp when this record was last processed
87	`max_offset_from_start`	`int`		Maximum offset from content start in seconds
88	`min_offset_from_start`	`int`		Minimum offset from content start in seconds
89	`operatorid`	`string`		Tenant identifier
90	`original_channel_id`	`string`		Original channel identifier
91	`original_channel_id_source`	`string`		Source of the original channel identifier
92	`original_channel_name`	`string`		Original channel name
93	`original_completion_percent`	`float`		Original content completion percentage
94	`playback_start_time_utc_corrected`	`timestamp`		Corrected UTC playback start timestamp
95	`session_duration_corrected_flag`	`boolean`		Whether the session duration was corrected
96	`source`	`string`		Source of the consumption data
97	`stg_ingestion_timestamp`	`timestamp`		Staging ingestion timestamp
98	`unique_id`	`string`	Yes	Unique content consumption record identifier (Primary Key)
99	`vod_name`	`string`		VOD content name

device_summary

Fact · MERGE

Daily aggregated metrics at the device level including activity counts, playback metrics, buffering statistics, and quality indicators. Essential for device-level performance analysis.

Property	Value
Primary Key	`date_day, accountid, deviceid`
Grain	One row per device per day
Bookmark Column	`ingestion_datetime`
Merge Lookback	72 hours
Retention	TBC
Column Count	39

#	Column Name	Type	PK	Description
1	`date_day`	`date`	Yes	Calendar date for aggregation in local timezone (Primary Key)
2	`operatorid`	`string`		Tenant identifier
3	`accountid`	`string`	Yes	Account identifier (Primary Key)
4	`device_publicid`	`string`		Public-facing device identifier
5	`deviceid`	`string`	Yes	Device identifier (Primary Key)
6	`account_number`	`string`		Account number for reference
7	`account_signon_id`	`string`		Account login identifier
8	`device_type`	`string`		Device category
9	`device_hardware_type`	`string`		Hardware type classification
10	`device_hardware_model`	`string`		Hardware model name
11	`device_hardware_manufacturer_name`	`string`		Device manufacturer name
12	`device_os_type`	`string`		Operating system type
13	`device_os_version`	`string`		Operating system version
14	`device_hardware_model_major_version`	`string`		Major version of the hardware model
15	`device_platform`	`string`		Platform classification combining device type and OS
16	`watch_count`	`bigint`		Number of watch events on this day
17	`watch_timestamp_utc`	`timestamp`		Most recent watch event timestamp
18	`favorite_count`	`bigint`		Number of favorite events on this day
19	`favorite_timestamp_utc`	`timestamp`		Most recent favorite event timestamp
20	`playererror_count`	`bigint`		Number of player errors on this day
21	`playererror_timestamp_utc`	`timestamp`		Most recent player error timestamp
22	`bookmark_count`	`bigint`		Number of bookmark events on this day
23	`bookmark_timestamp_utc`	`timestamp`		Most recent bookmark event timestamp
24	`history_count`	`bigint`		Number of history events on this day
25	`history_timestamp_utc`	`timestamp`		Most recent history event timestamp
26	`playbackstart_count`	`bigint`		Number of playback starts on this day
27	`playbackstart_timestamp_utc`	`timestamp`		Most recent playback start timestamp
28	`playbackstop_count`	`bigint`		Number of playback stops on this day
29	`playbackstop_timestamp_utc`	`timestamp`		Most recent playback stop timestamp
30	`total_activity_count`	`bigint`		Total count of all activity and playback metric events
31	`activity_datetime_utc`	`timestamp`		Most recent activity event timestamp
32	`resource_type`	`string`		Predominant content type accessed on this day
33	`lastlogindate_utc`	`timestamp`		Most recent login timestamp on this device
34	`total_login_count`	`bigint`		Total login events on this device
35	`playback_metrics_count`	`bigint`		Number of playback quality metric events
36	`playback_metrics_timestamp_utc`	`timestamp`		Most recent playback metrics timestamp
37	`playback_buffering_event_count`	`bigint`		Number of buffering events on this device
38	`playback_avg_bit_rate`	`double`		Average selected bitrate for playback on this device
39	`ingestion_datetime`	`timestamp`		Timestamp when this record was last processed

devices

Dimension · MERGE

Master data table for device information including hardware specifications, OS details, activation status, and device credentials. Links accounts to their registered devices.

Property	Value
Primary Key	`accountid, deviceid`
Grain	One row per device per account
Bookmark Column	`ingestion_datetime`
Retention	TBC
Column Count	44

#	Column Name	Type	PK	Description
1	`date_day`	`date`		Date portion of the device registration timestamp in local timezone
2	`operatorid`	`string`		Tenant identifier
3	`accountid`	`string`	Yes	Account that owns the device (Primary Key)
4	`deviceid`	`string`	Yes	Unique device identifier (Primary Key)
5	`device_name`	`string`		User-assigned device name
6	`created_at_utc`	`timestamp`		UTC timestamp when the device was registered
7	`updated_at_utc`	`timestamp`		UTC timestamp of the most recent device record update
8	`last_init_date`	`timestamp`		Last device initialization date
9	`activation_status`	`string`		Device activation status
10	`status`	`string`		Device status (e.g., ENABLED, DISABLED)
11	`device_type`	`string`		Device type category
12	`publicid`	`string`		Public-facing device identifier
13	`device_profile`	`string`		Device profile identifier
14	`device_profile_status`	`string`		Device profile status
15	`business_device_type`	`string`		Business device type
16	`is_unclassified`	`boolean`		Whether the device is marked as unclassified
17	`activation_date`	`timestamp`		Date when the device was activated
18	`casn`	`string`		Conditional Access Serial Number for managed devices
19	`initialization_status`	`string`		Device initialization status
20	`drm_client_id`	`string`		DRM client identifier
21	`drm_system_id`	`string`		DRM system identifier
22	`smartcard_id`	`string`		Smartcard identifier
23	`nuid`	`string`		Network Unique Identifier
24	`media_player_id`	`string`		Media player identifier
25	`credentials_state`	`string`		Device credentials state
26	`pin`	`string`		Device PIN
27	`wmk_id`	`string`		Watermark identifier
28	`device_hardware_id`	`string`		Hardware reference identifier
29	`device_hardware_type`	`string`		Hardware type classification
30	`device_hardware_model`	`string`		Specific hardware model name
31	`device_hardware_gpu_frequency`	`string`		GPU frequency specification
32	`device_hardware_gpu_cores`	`string`		GPU core count
33	`device_hardware_cpu_cores`	`string`		CPU core count
34	`device_hardware_cpu_frequency`	`string`		CPU frequency specification
35	`device_hardware_cpu_neon`	`string`		CPU NEON instruction support flag
36	`device_hardware_screen_density`	`string`		Screen density (DPI)
37	`device_hardware_screen_width`	`string`		Screen width in pixels
38	`device_hardware_screen_height`	`string`		Screen height in pixels
39	`device_hardware_manufacturer_name`	`string`		Device manufacturer name
40	`os_type`	`string`		Operating system type
41	`os_version`	`string`		Operating system version
42	`player_drm`	`string`		Player DRM type
43	`is_opf`	`boolean`		Data source indicator flag
44	`ingestion_datetime`	`timestamp`		Timestamp when this record was last processed

editorialcontentlocalizedattributes

Dimension · APPEND

Localized editorial content attributes including titles, synopses, cast, crew, genre, categories, and descriptions by locale.

Property	Value
Primary Key	`N/A`
Grain	One row per editorial content item and locale
Bookmark Column	`ingestion_datetime`
Retention	TBC
Column Count	13

#	Column Name	Type	Description
1	`operatorid`	`string`	Tenant identifier
2	`editorialcontentid`	`string`	Editorial content identifier
3	`locale`	`string`	Locale code
4	`title`	`string`	Localized content title
5	`synopsis`	`string`	Localized content synopsis
6	`episodetitle`	`string`	Localized episode title
7	`actors`	`string`	Actor information
8	`shorttitle`	`string`	Localized short title
9	`genre`	`string`	Localized genre labels
10	`directors`	`string`	Director information
11	`categories`	`string`	Localized content categories
12	`description`	`string`	Localized content description
13	`ingestion_datetime`	`timestamp`	Data ingestion timestamp

eventlocalizedattributes

Dimension · APPEND

Localized event metadata including titles, descriptions, episode labels, synopses, genre, and categories by locale.

Property	Value
Primary Key	`N/A`
Grain	One row per event and locale
Bookmark Column	`ingestion_datetime`
Retention	TBC
Column Count	10

#	Column Name	Type	Description
1	`operatorid`	`string`	Tenant identifier
2	`eventid`	`string`	Event identifier
3	`locale`	`string`	Locale code
4	`title`	`string`	Localized event title
5	`description`	`string`	Localized event description
6	`episode`	`string`	Localized episode label
7	`synopsis`	`string`	Localized event synopsis
8	`genre`	`string`	Localized genre labels
9	`categories`	`string`	Localized event categories
10	`ingestion_datetime`	`timestamp`	Data ingestion timestamp

playback_metrics

Fact (Raw) · APPEND

Raw playback quality of experience metrics including bitrate, buffering, frame, device network, content, and playback session attributes.

Property	Value
Primary Key	`N/A`
Grain	One row per playback metric activity event
Bookmark Column	`ingestion_datetime`
Retention	TBC
Column Count	31

#	Column Name	Type	Description
1	`operatorid`	`string`	Tenant identifier
2	`activityid`	`string`	Playback metric activity identifier
3	`selectedbitrate`	`double`	Selected playback bitrate
4	`createddatetime`	`timestamp`	UTC timestamp when the playback metric was created
5	`accountid`	`string`	Account identifier
6	`name`	`string`	Playback metric event name
7	`userid`	`string`	User profile identifier
8	`deviceid`	`string`	Device identifier
9	`contentid`	`string`	Content identifier
10	`availablebitrates`	`string`	Available bitrate options
11	`bytesdownloaded`	`double`	Bytes downloaded
12	`downloadbitrate`	`double`	Download bitrate
13	`downloadbitrateaverage`	`double`	Average download bitrate
14	`uri`	`string`	Playback media URI
15	`bufferedduration`	`double`	Buffered playback duration
16	`streambitrate`	`double`	Stream bitrate
17	`droppedvideoframes`	`double`	Dropped video frame count
18	`totalvideoframes`	`double`	Total video frame count
19	`contenttype`	`string`	Content type
20	`appsessionid`	`string`	Application session identifier
21	`playbacksessionid`	`string`	Playback session identifier
22	`playbackprogress`	`string`	Playback progress
23	`activitymetadataid`	`string`	Activity metadata reference
24	`contentsource`	`string`	Content delivery source
25	`rssi`	`string`	Received signal strength indicator
26	`signalstrength`	`string`	Signal strength
27	`usedfrequency`	`string`	Wireless frequency
28	`wifistandard`	`string`	Wi-Fi standard
29	`cdndownloadspeed`	`string`	CDN download speed
30	`ssid`	`string`	Wireless network SSID
31	`ingestion_datetime`	`timestamp`	Data ingestion timestamp

playback_session

Fact · MERGE

Detailed playback session data including session timing, quality indicators, content information, and performance statistics. Primary table for video playback analytics.

Property	Value
Primary Key	`session_unique_id`
Grain	One row per playback session
Bookmark Column	`ingestion_datetime`
Merge Lookback	72 hours
Retention	TBC
Column Count	41

#	Column Name	Type	PK	Description
1	`date_day`	`date`		Calendar date of the playback session start in local timezone
2	`operatorid`	`string`		Tenant identifier
3	`accountid`	`string`		Account identifier
4	`account_number`	`string`		Account number for reference
5	`account_signon_id`	`string`		Account login identifier
6	`deviceid`	`string`		Device identifier
7	`device_publicid`	`string`		Public-facing device identifier
8	`device_type`	`string`		Device category
9	`device_hardware_type`	`string`		Hardware type classification
10	`device_hardware_model`	`string`		Hardware model name
11	`device_hardware_manufacturer_name`	`string`		Device manufacturer name
12	`device_os_type`	`string`		Operating system type
13	`device_os_version`	`string`		Operating system version
14	`application_name`	`string`		Client application name
15	`application_version`	`string`		Client application version
16	`appsessionid`	`string`		Application session identifier
17	`playbacksessionid`	`string`		Playback session identifier
18	`session_unique_id`	`string`	Yes	Unique surrogate key for the playback session (Primary Key)
19	`playbackstarttime`	`timestamp`		UTC timestamp when playback started
20	`playbackendtime`	`timestamp`		UTC timestamp when playback ended (may be NULL if no stop event)
21	`int_endtime`	`timestamp`		Inferred session end time based on next session start
22	`playeddurationinsec`	`bigint`		Actual playback duration in seconds
23	`contentid`	`string`		Content identifier for the played content
24	`contenttype`	`string`		Content type classification: live, vod, or recording
25	`resourcetype`	`string`		Original resource type from the activity event
26	`bookmarkposition`	`bigint`		Last known playback position in seconds (for resume functionality)
27	`avg_selected_bitrate`	`double`		Average selected video bitrate during the session
28	`sum_bytes_downloaded`	`bigint`		Total bytes downloaded during the session
29	`avg_download_bitrate`	`double`		Average download bitrate during the session
30	`total_buffering_seconds`	`double`		Total time spent buffering in seconds
31	`avg_stream_bitrate`	`double`		Average stream bitrate during the session
32	`avg_framedrops`	`double`		Average frame drops during the session
33	`sum_framedrops`	`bigint`		Total number of frame drops during the session
34	`total_videoframes`	`bigint`		Total number of video frames rendered
35	`max_available_bitrates`	`string`		Maximum available bitrates for the stream
36	`count_bitrate_downgrades`	`bigint`		Number of bitrate downgrade events during the session
37	`count_buffering_event`	`bigint`		Number of buffering events during the session
38	`count_error_events`	`bigint`		Number of error events during the session
39	`playbackgeneratedendtime`	`timestamp`		Calculated session end time (uses actual end, or estimated from duration/next session)
40	`playbacksessionduration`	`bigint`		Total session duration in seconds
41	`ingestion_datetime`	`timestamp`		Timestamp when this record was last processed

privacyactivity

Fact (Raw) · APPEND

Raw privacy consent and policy events capturing user privacy preferences, consent acknowledgments, and compliance interactions.

Property	Value
Primary Key	`N/A`
Grain	One row per privacy consent/policy event
Bookmark Column	`ingestion_datetime`
Retention	TBC
Column Count	15

#	Column Name	Type	Description
1	`operatorid`	`string`	Tenant identifier
2	`date_day`	`date`	Date of privacy event in local timezone
3	`accountid`	`string`	Account identifier
4	`privacyactivityid`	`bigint`	Unique privacy activity identifier
5	`deviceid`	`string`	Device identifier
6	`userprofileid`	`string`	User profile identifier
7	`action`	`string`	Privacy action type
8	`key`	`string`	Privacy key/category
9	`value`	`string`	Consent value
10	`policy_version`	`string`	Privacy policy version
11	`privacy_id`	`string`	Privacy policy reference
12	`created_at_utc`	`timestamp`	UTC event timestamp
13	`updated_at_utc`	`timestamp`	UTC last update timestamp
14	`activity_datetime_utc`	`timestamp`	Privacy action timestamp
15	`ingestion_datetime`	`timestamp`	Data ingestion timestamp

purchaseactivity

Fact (Raw) · APPEND

Raw purchase transaction events capturing product purchases, subscription activations, rentals, and transaction outcomes. Essential for revenue analytics and billing reconciliation.

Property	Value
Primary Key	`N/A`
Grain	One row per purchase transaction event
Bookmark Column	`ingestion_datetime`
Retention	TBC
Column Count	21

#	Column Name	Type	Description
1	`operatorid`	`string`	Tenant identifier
2	`date_day`	`date`	Date of purchase event in local timezone
3	`accountid`	`string`	Account identifier
4	`purchaseactivityid`	`bigint`	Unique purchase identifier
5	`deviceid`	`string`	Device identifier
6	`userprofileid`	`string`	User profile identifier
7	`action`	`string`	Purchase action type
8	`status`	`string`	Transaction status
9	`product_id`	`string`	Product identifier
10	`product_name`	`string`	Product name
11	`product_type`	`string`	Product type
12	`price`	`decimal(10,2)`	Transaction price
13	`currency`	`string`	Currency code
14	`entitlement_id`	`string`	Entitlement identifier
15	`entitlement_start`	`timestamp`	Entitlement start date
16	`entitlement_end`	`timestamp`	Entitlement end date
17	`payment_method`	`string`	Payment method
18	`transaction_id`	`string`	Payment transaction reference
19	`created_at_utc`	`timestamp`	UTC purchase timestamp
20	`activity_datetime_utc`	`timestamp`	Purchase action timestamp
21	`ingestion_datetime`	`timestamp`	Data ingestion timestamp

subscriptions

Dimension · MERGE

Account subscription and entitlement information including package details, validity periods, and subscription status.

Property	Value
Primary Key	`accountid, entitlementid`
Grain	One row per subscription per account
Bookmark Column	`ingestion_datetime`
Retention	TBC
Column Count	57

#	Column Name	Type	PK	Description
1	`date_day`	`date`		Date of the subscription creation in local timezone
2	`entitlementid`	`string`	Yes	Unique subscription identifier (Primary Key)
3	`operatorid`	`string`		Tenant identifier
4	`accountid`	`string`	Yes	Account identifier (Primary Key)
5	`account_number`	`string`		Account number for reference
6	`account_signon_id`	`string`		Account login identifier
7	`productid`	`string`		Product identifier
8	`deviceid`	`string`		Device identifier associated with the subscription
9	`device_publicid`	`string`		Public-facing device identifier
10	`device_type`	`string`		Device category
11	`device_hardware_type`	`string`		Hardware type classification
12	`device_hardware_model`	`string`		Hardware model name
13	`device_hardware_manufacturer_name`	`string`		Device manufacturer name
14	`device_os_type`	`string`		Operating system type
15	`device_os_version`	`string`		Operating system version
16	`created_at_utc`	`timestamp`		UTC timestamp when the subscription was created
17	`updated_at_utc`	`timestamp`		UTC timestamp of the most recent subscription update
18	`last_bill_datetime`	`timestamp`		Last billing date and time
19	`user_id`	`string`		User identifier
20	`status`	`string`		Subscription status
21	`validity_type`	`string`		Subscription validity type
22	`purchased_offer`	`string`		Purchased offer identifier
23	`valid_from`	`timestamp`		Subscription start date
24	`expiry_date`	`timestamp`		Subscription expiry date
25	`first_view`	`timestamp`		Timestamp of first content view under this subscription
26	`unsubscription_date`	`timestamp`		Date when the subscription was cancelled
27	`is_freemium`	`boolean`		Whether this is a free-tier subscription
28	`capability_type`	`string`		Subscription capability type
29	`shared_product_content_id`	`string`		Shared product content identifier
30	`is_archivable`	`boolean`		Whether the subscription supports archival
31	`product_type`	`string`		Product type classification
32	`purchasedby_device_publicid`	`string`		Device used for the purchase
33	`part_of_pack`	`string`		Parent bundle/pack identifier if applicable
34	`parent_entitlement`	`string`		Parent subscription identifier for hierarchical entitlements
35	`product_name`	`string`		Product/package name
36	`producttypeid`	`string`		Product type identifier
37	`price`	`double`		Subscription price
38	`currency`	`string`		Price currency code
39	`purchase_start_date`	`timestamp`		Purchase availability start date
40	`purchase_end_date`	`timestamp`		Purchase availability end date
41	`provider_id`	`string`		Content provider identifier
42	`provider_resource_id`	`string`		Provider's resource identifier
43	`shared_product`	`string`		Shared product indicator
44	`technical_types`	`string`		Technical types supported by the subscription
45	`freemium_start_date`	`timestamp`		Free trial/freemium period start date
46	`freemium_end_date`	`timestamp`		Free trial/freemium period end date
47	`freemium_validity_period`	`string`		Free trial/freemium validity duration
48	`rights_impulsive`	`boolean`		Whether impulsive purchase is allowed
49	`rights_rental_duration`	`string`		Rental duration
50	`rights_consumption_window`	`string`		Content consumption window
51	`rights_storage_allowed`	`boolean`		Whether content storage/download is allowed
52	`scope`	`string`		Product scope
53	`private_metadata`	`string`		Additional product metadata
54	`product_product_type`	`string`		Product description type
55	`locale`	`string`		Product locale
56	`title`	`string`		Product title
57	`ingestion_datetime`	`timestamp`		Timestamp when this record was last processed