Bergamot
Views on data from bergamot
custom
App-specific view for Glean ping "custom"
bergamot.custom
This a view that UNIONs the stable ping tables across all channels of the Glean application "Bergamot Translator" (org_mozilla_bergamot.custom).
It is used by Looker.
| Column | Description | Type | Nullable |
|---|---|---|---|
| normalized_app_id | App ID of the channel data was received from | String | Yes |
| normalized_channel | Normalized channel name | String | Yes |
| additional_properties | String | Yes | |
| client_info | Record | Yes | |
| document_id | String | Yes | |
| events | Record | No | |
| metadata | Record | Yes | |
| metrics | Record | Yes | |
| normalized_app_name | String | Yes | |
| normalized_country_code | String | Yes | |
| normalized_os | String | Yes | |
| normalized_os_version | String | Yes | |
| ping_info | Record | Yes | |
| sample_id | Integer | Yes | |
| submission_timestamp | Timestamp | Yes |
| 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 a view that UNIONs the stable ping tables across all channels of the Glean application "Bergamot Translator" (org_mozilla_bergamot.deletion_request).
It is used by Looker.
| Column | Description | Type | Nullable |
|---|---|---|---|
| normalized_app_id | App ID of the channel data was received from | String | Yes |
| normalized_channel | Normalized channel name | String | Yes |
| additional_properties | String | Yes | |
| client_info | Record | Yes | |
| document_id | String | Yes | |
| events | Record | No | |
| metadata | Record | Yes | |
| metrics | Record | Yes | |
| normalized_app_name | String | Yes | |
| normalized_country_code | String | Yes | |
| normalized_os | String | Yes | |
| normalized_os_version | String | Yes | |
| ping_info | Record | Yes | |
| sample_id | Integer | Yes | |
| submission_timestamp | Timestamp | Yes |
| 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 a view that UNIONs the stable ping tables across all channels of the Glean application "Bergamot Translator" (org_mozilla_bergamot.events).
It is used by Looker.
| Column | Description | Type | Nullable |
|---|---|---|---|
| normalized_app_id | App ID of the channel data was received from | String | Yes |
| normalized_channel | Normalized channel name | String | Yes |
| additional_properties | String | Yes | |
| client_info | Record | Yes | |
| document_id | String | Yes | |
| events | Record | No | |
| metadata | Record | Yes | |
| metrics | Record | Yes | |
| normalized_app_name | String | Yes | |
| normalized_country_code | String | Yes | |
| normalized_os | String | Yes | |
| normalized_os_version | String | Yes | |
| ping_info | Record | Yes | |
| sample_id | Integer | Yes | |
| submission_timestamp | Timestamp | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | org_mozilla_bergamot | events |
Source Directory | View Definition | Metadata File
events_unnested
Events Unnested
bergamot.events_unnested
Please provide a description for the query
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | org_mozilla_bergamot | events |
Source Directory | View Definition | Metadata File