Skip to content

viu-politica

User-facing views related to document namespace viu-politica; see https://github.com/mozilla-services/mozilla-pipeline-schemas/tree/generated-schemas/schemas/viu-politica

Source Directory

deletion_request

Historical Pings for viu-politica/deletion-request

viu_politica.deletion_request

A historical view of pings sent for the viu-politica/deletion-request document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
client_info Record Yes
document_id The document ID specified in the URI when the client sent this message String Yes
events Record No
metadata Record Yes
metrics Record Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
ping_info Record Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod viu_politica_stable deletion_request_v1

Source Directory | View Definition | Metadata File


events

Historical Pings for viu-politica/events

viu_politica.events

A historical view of pings sent for the viu-politica/events document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
client_info Record Yes
document_id The document ID specified in the URI when the client sent this message String Yes
events Record No
metadata Record Yes
metrics Record Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
ping_info Record Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod viu_politica_stable events_v1

Source Directory | View Definition | Metadata File


events_unnested

Events Unnested

viu_politica.events_unnested

Please provide a description for the query

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod viu_politica events

Source Directory | View Definition | Metadata File


main_events

Historical Pings for viu-politica/main-events

viu_politica.main_events

A historical view of pings sent for the viu-politica/main-events document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
client_info Record Yes
document_id The document ID specified in the URI when the client sent this message String Yes
events Record No
metadata Record Yes
metrics Record Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
ping_info Record Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod viu_politica_stable main_events_v1

Source Directory | View Definition | Metadata File


regret_details

Historical Pings for viu-politica/regret-details

viu_politica.regret_details

A historical view of pings sent for the viu-politica/regret-details document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
client_info Record Yes
document_id The document ID specified in the URI when the client sent this message String Yes
events Record No
metadata Record Yes
metrics Record Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
ping_info Record Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod viu_politica_stable regret_details_v1

Source Directory | View Definition | Metadata File


video_data

Historical Pings for viu-politica/video-data

viu_politica.video_data

A historical view of pings sent for the viu-politica/video-data document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
client_info Record Yes
document_id The document ID specified in the URI when the client sent this message String Yes
events Record No
metadata Record Yes
metrics Record Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
ping_info Record Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod viu_politica_stable video_data_v1

Source Directory | View Definition | Metadata File


video_index

Historical Pings for viu-politica/video-index

viu_politica.video_index

A historical view of pings sent for the viu-politica/video-index document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

Schema
Column Description Type Nullable
additional_properties A JSON string containing any payload properties not present in the schema String Yes
client_info Record Yes
document_id The document ID specified in the URI when the client sent this message String Yes
events Record No
metadata Record Yes
metrics Record Yes
normalized_app_name Set to "Other" if this message contained an unrecognized app name String Yes
normalized_channel Set to "Other" if this message contained an unrecognized channel name String Yes
normalized_country_code An ISO 3166-1 alpha-2 country code String Yes
normalized_os Set to "Other" if this message contained an unrecognized OS name String Yes
normalized_os_version String Yes
ping_info Record Yes
sample_id Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 Integer Yes
submission_timestamp Time when the ingestion edge server accepted this message Timestamp Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod viu_politica_stable video_index_v1

Source Directory | View Definition | Metadata File