Skip to content

org-mozilla-klar

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

Source Directory

activation

Historical Pings for org-mozilla-klar/activation

org_mozilla_klar.activation

A historical view of pings sent for the org-mozilla-klar/activation 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 org_mozilla_klar_stable activation_v1

Source Directory | View Definition | Metadata File


baseline

Historical Pings for org-mozilla-klar/baseline

org_mozilla_klar.baseline

A historical view of pings sent for the org-mozilla-klar/baseline 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 org_mozilla_klar_stable baseline_v1

Source Directory | View Definition | Metadata File


baseline_clients_daily

Baseline Clients Daily

org_mozilla_klar.baseline_clients_daily

A daily aggregate of baseline pings per client_id.

Clustering fields: normalized_channel, sample_id

See also: baseline_clients_last_seen

Schema
Column Description Type Nullable
submission_date Date Yes
client_id String Yes
sample_id Integer Yes
first_run_date Date Yes
durations Integer Yes
days_seen_session_start_bits Integer Yes
days_seen_session_end_bits Integer Yes
normalized_channel String Yes
normalized_os String Yes
normalized_os_version String Yes
android_sdk_version String Yes
locale String Yes
city String Yes
country String Yes
isp String Yes
app_build String Yes
app_channel String Yes
app_display_version String Yes
architecture String Yes
device_manufacturer String Yes
device_model String Yes
telemetry_sdk_build String Yes
first_seen_date Date Yes
is_new_profile Boolean Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod org_mozilla_klar_derived baseline_clients_daily_v1

Source Directory | View Definition | Metadata File


baseline_clients_first_seen

Baseline Clients First Seen

org_mozilla_klar.baseline_clients_first_seen

Captures the earliest server date that we observe a particular client in the baseline table. A client may have a first_seen_date that is earlier than the epoch of the baseline table; this is the result of a migration from a legacy data collection system. These clients are therefore not captured in this table.

Clustering fields: sample_id

See also: baseline_clients_daily and baseline_clients_last_seen.

Schema
Column Description Type Nullable
submission_date Date Yes
client_id String Yes
sample_id Integer Yes
first_run_date Date Yes
durations Integer Yes
days_seen_session_start_bits Integer Yes
days_seen_session_end_bits Integer Yes
normalized_channel String Yes
normalized_os String Yes
normalized_os_version String Yes
android_sdk_version String Yes
locale String Yes
city String Yes
country String Yes
isp String Yes
app_build String Yes
app_channel String Yes
app_display_version String Yes
architecture String Yes
device_manufacturer String Yes
device_model String Yes
telemetry_sdk_build String Yes
first_seen_date Date Yes
is_new_profile Boolean Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod org_mozilla_klar_derived baseline_clients_daily_v1

Source Directory | View Definition | Metadata File


baseline_clients_last_seen

Baseline Clients Last Seen

org_mozilla_klar.baseline_clients_last_seen

Captures activity history of each client in 28-day windows for each submission date based on baseline pings.

Clustering fields: normalized_channel, sample_id

See also: baseline_clients_daily

Schema
Column Description Type Nullable
days_since_seen Integer Yes
days_since_created_profile Integer Yes
days_since_seen_session_start Integer Yes
days_since_seen_session_end Integer Yes
days_seen_bits Integer Yes
days_created_profile_bits Integer Yes
submission_date Date Yes
client_id String Yes
sample_id Integer Yes
first_run_date Date Yes
durations Integer Yes
days_seen_session_start_bits Integer Yes
days_seen_session_end_bits Integer Yes
normalized_channel String Yes
normalized_os String Yes
normalized_os_version String Yes
android_sdk_version String Yes
locale String Yes
city String Yes
country String Yes
isp String Yes
app_build String Yes
app_channel String Yes
app_display_version String Yes
architecture String Yes
device_manufacturer String Yes
device_model String Yes
telemetry_sdk_build String Yes
first_seen_date Date Yes
is_new_profile Boolean Yes
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod org_mozilla_klar_derived baseline_clients_last_seen_v1

Source Directory | View Definition | Metadata File


deletion_request

Historical Pings for org-mozilla-klar/deletion-request

org_mozilla_klar.deletion_request

A historical view of pings sent for the org-mozilla-klar/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 org_mozilla_klar_stable deletion_request_v1

Source Directory | View Definition | Metadata File


events

Historical Pings for org-mozilla-klar/events

org_mozilla_klar.events

A historical view of pings sent for the org-mozilla-klar/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 org_mozilla_klar_stable events_v1

Source Directory | View Definition | Metadata File


fog_validation

Historical Pings for org-mozilla-klar/fog-validation

org_mozilla_klar.fog_validation

A historical view of pings sent for the org-mozilla-klar/fog-validation 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 org_mozilla_klar_stable fog_validation_v1

Source Directory | View Definition | Metadata File


metrics

Historical Pings for org-mozilla-klar/metrics

org_mozilla_klar.metrics

A historical view of pings sent for the org-mozilla-klar/metrics 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 org_mozilla_klar_stable metrics_v1

Source Directory | View Definition | Metadata File