* Prepare active_users_aggregates for a backfill with shredder mitigation. Rename columns [first_seen_date, os_version, segment] to cascade upstream changes during the backfill for stable numbers.
* Update CODEOWNERS with the new version.
* Avoid modifying the active_users_aggregates view until the new version is backfilled. Remove the view generation from the new version which conflicts with previous version.
* Generate DAG with version.
* Adjust schema to query.
* Ensure attribution columns are present in mobile's schema.
* Convert NULLS in city to '??' as required by existing data.
* Remove uri_count, active_hours from views. Missing 'AS' added to to query.
* Separate DAU metrics
* Combine desktop + mobile DAU queries
* Fix CI failure
Fix CI failure
* Remove eligible markets, reduce group bys
* Update desktop DAU and revert new mobile bug
* Fix sql file format
---------
Co-authored-by: skahmann3 <16420065+skahmann3@users.noreply.github.com>
* Add QDAU definition for mobile and publish as DAU in telemetry.active_users_aggregates.
* DENG-1833. submission_date parameter back.
* DENG-1833. Reformat.
* Add QDAU definition for mobile and publish as DAU in telemetry.active_users_aggregates.
* DENG-1833. submission_date parameter back.
* DENG-1833. Reformat.
* DENG-1833. Remove unrequired filter.
* DENG-1911. Rename dau to all_dau and qdau to dau.
* DENG-1911. Upgrade active_users_aggregates table version due to change in metric definition.
* DENG-1911. Update naming to daily_users metric.
* DENG-1911. Update metadata.
* DENG-1911. Update change control.
---------
Co-authored-by: Lucia Vargas <lvargas@mozilla.com>
* add query_id and username columns to bigquery_usage_v2 table - joining JOBS_BY_ORG and JOBS_BY_PROJECT tables
* change jobs_by_project query to use variable {project} instead of
* adjust formatting
* refactor query to use jobs_by_organization_derived table
* remove data ops from codeowner of bigquery_table_usage_v2
* add marlene as a code owner to the bigquery_table_usage_v2 table
* add marlene as owner to DAG for bq_table_usage_v2
* change underscore to dot to properly identify field: query_info.query_hashes.normalized_literals
* add mozilla/dataops for jobs_by_org_v1 to CODEOWNERS file
* DS-2998- Add attribution data to aua
Add att to aua
Fix sql format CI error
Fix CI Issue
* Fix the mobile scripts
Generate dags to fix CI
* Fix desktop query to remove um reference
Fix dag generate
Generate dags
* Regenerate firefox_ios and kpi_shredder dag
* Remove desktop query and bump mobile versions to v2
* Change to v2 for CODEOWNERS file
* revert desktop sql template to remove attr cols
* Incorporate changes based on Lucia's feedback
* Remove search columns from the final view
* DENG-774 Add change control to active_users_aggregates and test.
* DENG-774 Add test coverage.
---------
Co-authored-by: Lucia Vargas <lvargas@mozilla.com>
This minimal CODEOWNERS file will automatically tag relud and jklukas
for review on PRs in this repository.
It's my assumption that we generally want to be aware of changes
happening here, so getting auto-tagged is a good thing, but let me
know if you disagree.
Lucia
Alekhya
skahmann3
whd
Sean Rose
Daniel Thorn
Marlene Hirose
Winnie Chan
Jeff Klukas
Jeff Klukas