sql/moz-fx-data-shared-prod/firefox_accounts/fxa_content_auth_stdout_events/view.sql

-----
--- ** DEPRECATION NOTICE **
---
--- There is currently an ongoing effort to deprecate this view
--- please use `firefox_accounts.fxa_all_events` view instead
--- in new queries.
---
--- Please filter on `fxa_log` field to limit your results
--- to events coming only from a specific fxa server like so:
--- WHERE fxa_log IN ('auth', 'stdout', ...)
--- Options include:
---   content
---   auth
---   stdout
---   oauth -- this has been deprecated and merged into fxa_auth_event
---   auth_bounce
--- to replicate results of this view use:
--- WHERE fxa_log IN (
---  'content',
---  'auth',
---  'stdout',
---  'payments'
--- )
--------
-- In the meantime, this view points to the fxa_all_events view
-- while maintaining filtering rules to only include certain events for backward compatibility.
-----
CREATE OR REPLACE VIEW
  `moz-fx-data-shared-prod.firefox_accounts.fxa_content_auth_stdout_events`
AS
SELECT
  logger,
  event_type,
  app_version,
  os_name,
  os_version,
  country,
  country_code,
  `language`,
  user_id,
  device_id,
  `timestamp`,
  receiveTimestamp,
  event_time,
  utm_term,
  utm_source,
  utm_medium,
  utm_campaign,
  utm_content,
  ua_version,
  ua_browser,
  entrypoint,
  entrypoint_experiment,
  entrypoint_variation,
  flow_id,
  service,
  email_type,
  email_provider,
  oauth_client_id,
  connect_device_flow,
  connect_device_os,
  sync_device_count,
  sync_active_devices_day,
  sync_active_devices_week,
  sync_active_devices_month,
  email_sender,
  email_service,
  email_template,
  email_version,
  subscription_id,
  plan_id,
  previous_plan_id,
  subscribed_plan_ids,
  product_id,
  previous_product_id,
  promotion_code,
  payment_provider,
  provider_event_id,
  checkout_type,
  source_country,
  country_code_source,
  error_id,
  voluntary_cancellation,
FROM
  `moz-fx-data-shared-prod.firefox_accounts.fxa_all_events`
WHERE
  fxa_log IN ("content", "auth", "stdout", "payments")