Skip to content

Bergamot

Views on data from bergamot

Source Directory

custom

App-specific view for Glean ping "custom"

bergamot.custom

This is a pointer to the main view to the stable ping table for the release channel of the Glean application "Bergamot Translator" (moz-fx-data-shared-prod.org_mozilla_bergamot.custom).

It is used by Looker.

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 org_mozilla_bergamot custom

Source Directory | View Definition | Metadata File


deletion_request

App-specific view for Glean ping "deletion-request"

bergamot.deletion_request

This is a pointer to the main view to the stable ping table for the release channel of the Glean application "Bergamot Translator" (moz-fx-data-shared-prod.org_mozilla_bergamot.deletion_request).

It is used by Looker.

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 org_mozilla_bergamot deletion_request

Source Directory | View Definition | Metadata File


events

App-specific view for Glean ping "events"

bergamot.events

This is a pointer to the main view to the stable ping table for the release channel of the Glean application "Bergamot Translator" (moz-fx-data-shared-prod.org_mozilla_bergamot.events).

It is used by Looker.

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 org_mozilla_bergamot events

Source Directory | View Definition | Metadata File


events_unnested

bergamot.events_unnested

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

Source Directory | View Definition | Metadata File