bigquery-etl/sql/moz-fx-data-shared-prod/relay
Yeonjoo Yoo 93df05550d
(DS-2284, DS-2520)Creating Relay derived tables and views for Relay SaaSboard (#3482)
* relay dataset and data tables are created

* added country_name columns to all tables

* reformat query files for circle ci error fixing

* Schema edited and dry run list updated

* removing status column in multiple places

* matching date_partition_offset setting with the table

Co-authored-by: Sean Rose <1994030+sean-rose@users.noreply.github.com>

* keep the consistency of friendly_name

Co-authored-by: Sean Rose <1994030+sean-rose@users.noreply.github.com>

* removing unnecessary comment

* subscriptions query updated

* renaming a CTE

Co-authored-by: Sean Rose <1994030+sean-rose@users.noreply.github.com>

* subscriptions_v1 schema editted

* add "relay-phones" to be included for filtering

Co-authored-by: Sean Rose <1994030+sean-rose@users.noreply.github.com>
2023-01-10 17:54:34 -05:00
..
active_subscription_ids (DS-2284, DS-2520)Creating Relay derived tables and views for Relay SaaSboard (#3482) 2023-01-10 17:54:34 -05:00
active_subscriptions (DS-2284, DS-2520)Creating Relay derived tables and views for Relay SaaSboard (#3482) 2023-01-10 17:54:34 -05:00
subscription_events (DS-2284, DS-2520)Creating Relay derived tables and views for Relay SaaSboard (#3482) 2023-01-10 17:54:34 -05:00
subscriptions (DS-2284, DS-2520)Creating Relay derived tables and views for Relay SaaSboard (#3482) 2023-01-10 17:54:34 -05:00
dataset_metadata.yaml (DS-2284, DS-2520)Creating Relay derived tables and views for Relay SaaSboard (#3482) 2023-01-10 17:54:34 -05:00