* Create iOS_onboarding.toml
Added iOS_onboarding.toml - query for generating the underlying table in the iOS onboarding dashboard.
* Update iOS_onboarding.toml
* feat: remove locale from dimension list, it does not exist in the source table
* Delete sql_generators/funnels/configs/iOS_onboarding.toml
* Create ios_onboarding.toml
updated to lower case file name and removed "locale" since it doesn't exist in firefox_ios_clients
* add a line in bqetl_project.yaml to avoid dry run
---------
Co-authored-by: kik-kik <kignasiak@mozilla.com>
* Switch to baseline beginning Aug 01st 2024
* Modify the search_engine_daily view to handle the cut off
* Fix sql format
* Skip mobile_clients_daily_v2 from dry run
* Remove sql_generator files populating v1
* Add tests for mobile_search_clients_daily_v2
* remove unwanted tests
* Bug 1905938 Support events with no metrics in glean_usage generator
* fix event_error_monitoring
* not
* Apply suggestions from code review
Co-authored-by: Sean Rose <1994030+sean-rose@users.noreply.github.com>
---------
Co-authored-by: Sean Rose <1994030+sean-rose@users.noreply.github.com>
* feat: add BigEye RunMetricOperator to DAG generation
* Fix Bigeye DAG generation and move configuration to bqetl_project.yaml
* Reformatting; test fixing
* Install Airflow override requirements
---------
Co-authored-by: Anna Scholtz <anna@scholtzan.net>
* Give reader role to dry run account for datasets in stage
* add sql changes to deploy
* hardcode service accounts
* Revert "add sql changes to deploy"
* Remove func in dryrun
* f
* DSRE-1681 create 2 new views in shared prod
* DSRE-1681 fix formatting on new views
* DSRE-1681 add metadata yaml files for the 2 new views with authorized true
* DSRE-1681 add SUMO access to the 2 new views
* Add better descriptions
* DSRE-1681 fix friendly names
* DSRE-1681 add the _TABLE_SUFFIX filters so it doesn't pull in data from the other tables with the same prefix, i.e. events_intraday_*
* DSRE-1681 Remove table-level access in favor of dataset access
* DSRE-1681 Add new sumo_ga views to dryrun skip
---------
Co-authored-by: Wesley Dawson <whd@mozilla.com>
* Remove deleted table from skip list
* Parse schema file in validate_shredder_mitigation function so it works on priv-bqetl
* Parse schema file in validate_shredder_mitigation function so it works on priv-bqetl
* Clean up test
This will generate events_stream and event_monitoring_live tables for ads_backend. We originally skipped this app because there was a delay in its ping table deployment.
* DENG-4691 Add views for Ray Serve compute costs for fakespot tenant
- To surface the total compute cost of all Ray Serve workloads of fakespot tenant
that are deployed via kuberay operator on "dataservices-high-nonprod"
shared GKE cluster
* Add PPA measurements w/o advertiser view
* Update metadata
* Add new PPA view to dry run skip list
* Should be an authorized view
* Rename table to _limited
* Remove percentiles
* Remove tests that test percentiles
* Refresh scripts insert null to new percentiles
* Remove percentile columns from queries and schemas
* Delete more percentile tables
* Formatting
* histogram_cast_struct's keys are strings
* Re-add test after fixing failure cause
* DENG-4201 create DL w attr v1 and v2 in shared prod
* Update to new paths in shared prod
* DENG-4201 update to v2 version in view.sql
* Update metadata.yaml
* Update metadata.yaml
* Update bqetl_project.yaml
* feat: add corresponding firefox ios web_referrer tables to be copied over to moz-prod
* feat: convert app_store_external to be a syndicate dateset
* fix: correct typo in the description anx syndication configuration.
* Add fully-qualified identifiers when formatting queries
* Fully-qualified identifiers for queries in sql/
* Check in only formatted SQL to generated-sql branch
* Add comment
* Fully qualify more tables
* Fully qualify test files
* Formatting improvements around CTEs and unit tests
* Option to skip auto qualifying queries
* Move Google Search Console ETLs & views to `moz-fx-data-shared-prod`.
* Temporarily add back Google Search Console views in `moz-fx-data-marketing-prod` to avoid breaking existing reporting.
* Update Google Search Console ETL entries in dry-run skip config.
* Temporarily add pass-through views in `moz-fx-data-marketing-prod` in place of Google Search Console ETL tables to avoid breaking existing reporting.
Ben Wu
Anna Scholtz
rzhao
Alekhya
whd
Katie Windau
kik-kik
Curtis Morales
Arkadiusz Komarzewski
akkomar
Abhishek Aggarwal
Chelsea Troy
Eduardo Filho
Sean Rose
wil stuckey