sql/moz-fx-data-shared-prod/firefox_accounts_derived/fxa_content_events

fields: - name: logName type: STRING mode: NULLABLE - name: resource type: RECORD mode: NULLABLE fields: - name: type type: STRING mode: NULLABLE - name: labels type: RECORD mode: NULLABLE fields: - name: instance_id type: STRING mode: NULLABLE - name: project_id type: STRING mode: NULLABLE - name: zone type: STRING mode: NULLABLE - name: textPayload type: STRING mode: NULLABLE - name: jsonPayload type: RECORD mode: NULLABLE fields: - name: type type: STRING mode: NULLABLE - name: pid type: FLOAT mode: NULLABLE - name: logger type: STRING mode: NULLABLE - name: timestamp type: FLOAT mode: NULLABLE - name: severity type: FLOAT mode: NULLABLE - name: envversion type: STRING mode: NULLABLE - name: fields type: RECORD mode: NULLABLE fields: - name: op type: STRING mode: NULLABLE - name: os_version type: STRING mode: NULLABLE - name: event_properties type: STRING mode: NULLABLE - name: event_type type: STRING mode: NULLABLE - name: country type: STRING mode: NULLABLE - name: os_name type: STRING mode: NULLABLE - name: time type: FLOAT mode: NULLABLE - name: language type: STRING mode: NULLABLE - name: user_properties type: STRING mode: NULLABLE - name: session_id type: FLOAT mode: NULLABLE - name: region type: STRING mode: NULLABLE - name: app_version type: STRING mode: NULLABLE - name: device_model type: STRING mode: NULLABLE - name: err type: STRING mode: NULLABLE - name: method type: STRING mode: NULLABLE - name: path type: STRING mode: NULLABLE - name: clientaddress type: STRING mode: NULLABLE - name: remoteaddresschain type: STRING mode: NULLABLE - name: useragent type: STRING mode: NULLABLE - name: status type: STRING mode: NULLABLE - name: t type: STRING mode: NULLABLE - name: contentlength type: STRING mode: NULLABLE - name: referer type: STRING mode: NULLABLE - name: violated type: STRING mode: NULLABLE - name: agent type: STRING mode: NULLABLE - name: source type: STRING mode: NULLABLE - name: line type: FLOAT mode: NULLABLE - name: blocked type: STRING mode: NULLABLE - name: column type: FLOAT mode: NULLABLE - name: referrer type: STRING mode: NULLABLE - name: sample type: STRING mode: NULLABLE - name: msg type: STRING mode: NULLABLE - name: error type: STRING mode: NULLABLE - name: stack type: STRING mode: NULLABLE - name: context type: STRING mode: NULLABLE - name: event type: STRING mode: NULLABLE - name: joierrors type: STRING mode: NULLABLE - name: user_id type: STRING mode: NULLABLE - name: device_id type: STRING mode: NULLABLE - name: config type: STRING mode: NULLABLE - name: tags type: STRING mode: NULLABLE - name: release type: STRING mode: NULLABLE - name: level type: STRING mode: NULLABLE - name: project type: STRING mode: NULLABLE - name: extra type: STRING mode: NULLABLE - name: request type: STRING mode: NULLABLE - name: exception type: STRING mode: NULLABLE - name: fingerprint type: STRING mode: NULLABLE - name: culprit type: STRING mode: NULLABLE - name: logger type: STRING mode: NULLABLE - name: event_id type: STRING mode: NULLABLE - name: platform type: STRING mode: NULLABLE - name: message type: STRING mode: NULLABLE - name: value type: STRING mode: NULLABLE - name: param type: STRING mode: NULLABLE - name: amplitudeevent type: STRING mode: NULLABLE - name: region type: STRING mode: NULLABLE - name: hostname type: STRING mode: NULLABLE - name: flow_id type: STRING mode: NULLABLE - name: flow_time type: FLOAT mode: NULLABLE - name: v type: FLOAT mode: NULLABLE - name: country type: STRING mode: NULLABLE - name: entrypoint type: STRING mode: NULLABLE - name: event type: STRING mode: NULLABLE - name: useragent type: STRING mode: NULLABLE - name: op type: STRING mode: NULLABLE - name: locale type: STRING mode: NULLABLE - name: service type: STRING mode: NULLABLE - name: context type: STRING mode: NULLABLE - name: utm_campaign type: STRING mode: NULLABLE - name: utm_medium type: STRING mode: NULLABLE - name: utm_content type: STRING mode: NULLABLE - name: utm_source type: STRING mode: NULLABLE - name: user_properties type: RECORD mode: NULLABLE fields: - name: ua_browser type: STRING mode: NULLABLE - name: utm_campaign type: STRING mode: NULLABLE - name: _append type: RECORD mode: NULLABLE fields: - name: fxa_services_used type: STRING mode: NULLABLE - name: experiments type: STRING mode: REPEATED - name: flow_id type: STRING mode: NULLABLE - name: entrypoint type: STRING mode: NULLABLE - name: utm_source type: STRING mode: NULLABLE - name: ua_version type: STRING mode: NULLABLE - name: utm_content type: STRING mode: NULLABLE - name: utm_medium type: STRING mode: NULLABLE - name: utm_term type: STRING mode: NULLABLE - name: newsletter_state type: STRING mode: NULLABLE - name: user_id type: STRING mode: NULLABLE - name: os_version type: STRING mode: NULLABLE - name: device_id type: STRING mode: NULLABLE - name: event_properties type: RECORD mode: NULLABLE fields: - name: service type: STRING mode: NULLABLE - name: reason type: STRING mode: NULLABLE - name: connect_device_flow type: STRING mode: NULLABLE - name: email_provider type: STRING mode: NULLABLE - name: email_type type: STRING mode: NULLABLE - name: oauth_client_id type: STRING mode: NULLABLE - name: connect_device_os type: STRING mode: NULLABLE - name: event_type type: STRING mode: NULLABLE - name: os_name type: STRING mode: NULLABLE - name: app_version type: STRING mode: NULLABLE - name: language type: STRING mode: NULLABLE - name: session_id type: FLOAT mode: NULLABLE - name: device_model type: STRING mode: NULLABLE - name: timestamp type: TIMESTAMP mode: NULLABLE - name: receiveTimestamp type: TIMESTAMP mode: NULLABLE - name: severity type: STRING mode: NULLABLE - name: insertId type: STRING mode: NULLABLE - name: httpRequest type: RECORD mode: NULLABLE fields: - name: requestMethod type: STRING mode: NULLABLE - name: requestUrl type: STRING mode: NULLABLE - name: requestSize type: INTEGER mode: NULLABLE - name: status type: INTEGER mode: NULLABLE - name: responseSize type: INTEGER mode: NULLABLE - name: userAgent type: STRING mode: NULLABLE - name: remoteIp type: STRING mode: NULLABLE - name: serverIp type: STRING mode: NULLABLE - name: referer type: STRING mode: NULLABLE - name: cacheLookup type: BOOLEAN mode: NULLABLE - name: cacheHit type: BOOLEAN mode: NULLABLE - name: cacheValidatedWithOriginServer type: BOOLEAN mode: NULLABLE - name: cacheFillBytes type: INTEGER mode: NULLABLE - name: protocol type: STRING mode: NULLABLE - name: labels type: RECORD mode: NULLABLE fields: - name: type type: STRING mode: NULLABLE - name: compute_googleapis_com_resource_name type: STRING mode: NULLABLE - name: application type: STRING mode: NULLABLE - name: env type: STRING mode: NULLABLE - name: stack type: STRING mode: NULLABLE - name: fxa________ type: STRING mode: NULLABLE - name: defau type: STRING mode: NULLABLE - name: cont type: STRING mode: NULLABLE - name: pro type: STRING mode: NULLABLE - name: fxa______pi type: STRING mode: NULLABLE - name: operation type: RECORD mode: NULLABLE fields: - name: id type: STRING mode: NULLABLE - name: producer type: STRING mode: NULLABLE - name: first type: BOOLEAN mode: NULLABLE - name: last type: BOOLEAN mode: NULLABLE - name: trace type: STRING mode: NULLABLE - name: spanId type: STRING mode: NULLABLE - name: traceSampled type: BOOLEAN mode: NULLABLE - name: sourceLocation type: RECORD mode: NULLABLE fields: - name: file type: STRING mode: NULLABLE - name: line type: INTEGER mode: NULLABLE - name: function type: STRING mode: NULLABLE - name: split type: RECORD mode: NULLABLE fields: - name: uid type: STRING mode: NULLABLE - name: index type: INTEGER mode: NULLABLE - name: totalSplits type: INTEGER mode: NULLABLE

sql/moz-fx-data-shared-prod/firefox_accounts_derived/fxa_content_events_v1/schema.yaml (511 lines of code) (raw):