Граф коммитов

6180 Коммитов

Автор SHA1 Сообщение Дата
Katie Windau 23e69328d5
Deprecate views associated with already deprecated tables (#6453) 2024-11-06 19:30:18 +00:00
Anna Scholtz ed7fc6b151
Update bigconfig.yaml to use tag_deployments (#6449) 2024-11-06 17:29:51 +00:00
dependabot[bot] f666107095
Bump mkdocs-material from 9.5.43 to 9.5.44 (#6452)
Bumps [mkdocs-material](https://github.com/squidfunk/mkdocs-material) from 9.5.43 to 9.5.44.
- [Release notes](https://github.com/squidfunk/mkdocs-material/releases)
- [Changelog](https://github.com/squidfunk/mkdocs-material/blob/master/CHANGELOG)
- [Commits](https://github.com/squidfunk/mkdocs-material/compare/9.5.43...9.5.44)

---
updated-dependencies:
- dependency-name: mkdocs-material
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
2024-11-06 17:08:21 +00:00
Ben Wu 69aba6a473
[DENG-5962] Change shredder state to only use end_date (#6450) 2024-11-06 15:19:10 +00:00
m-d-bowerman 221f44ca00
update telemetry for list cards (#6445)
* update telemetry for list cards

* update test yaml

* fix incorrect bool

---------

Co-authored-by: Chelsey Beck <64881557+chelseybeck@users.noreply.github.com>
2024-11-05 23:37:50 +00:00
Anna Scholtz 4ad4c6b9d4
Add CLI command to run Bigeye checks (#6383)
* Add support for defining custom SQL rules

* Added monitoring rollback command

* Reformat

* Add tests

* Address review feedback

* Add flags for deleting Bigeye checks

* Add support for defining custom SQL rules

* Added monitoring rollback command

* Add run command to trigger Bigeye checks

* Use bigquery_bigeye_check to trigger Bigeye runs

* Add unit tests for monitoring run CLI command

* Update DAG tests

* Fix imports

* Address review feedback

* Format custom sql rules file

* Remove bigconfig_custom_rules.sql

* Fix bigeye update for public datasets
2024-11-05 18:02:42 +00:00
Ben Wu 6e1e917317
Move event_monitoring_aggregates_v1 to run in on-demand billing (#6447) 2024-11-05 17:12:01 +00:00
Sean Rose b114127264
Exclude Fivetran's incorrect Stripe customer discount records from non-prod SubPlat ETLs. (#6444) 2024-11-05 16:52:41 +00:00
rzhao 695ec38dad
Create iOS_onboarding.toml (#6316)
* 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>
2024-11-05 16:47:22 +00:00
kik-kik 265ba349e3
feat: remove check causing a lot of noise that is unactionable from app_store_funnel_v1 (#6446) 2024-11-05 14:26:40 +00:00
Sean Rose 73f47fc0e3
Exclude Fivetran's incorrect Stripe customer discount records from SubPlat ETLs. (#6443) 2024-11-05 02:50:03 +00:00
Sean Rose 76351c7cfb
Update the `country_codes_v1.mozilla_vpn_available` column for VPN wave 7 expansion countries (DENG-5882). (#6442) 2024-11-05 02:47:30 +00:00
Sean Rose ecacb00e93
Update VPN ETL `in_available_geos` logic for when VPN became available in various countries (DENG-5484) (#6441)
* Add VPN wave 6 countries to `in_available_geos` logic.

* Add VPN wave 7 countries to `in_available_geos` logic.
2024-11-04 23:44:34 +00:00
Ben Wu a562844c2a
Add submission_date partition to ref table number in bigquery_usage (#6440) 2024-11-04 22:06:10 +00:00
Ben Wu 68cc748f90
Add reference table number to bigquery_usage view (#6439) 2024-11-04 19:28:19 +00:00
Anna Scholtz a264f0130a
Skip most of the Mozilla Social checks (#6438) 2024-11-04 18:15:09 +00:00
whd d9f0712d07
chore: switch to v2 workgroups for dataplatform access (#6368) 2024-11-04 18:12:47 +00:00
Anna Scholtz 209b75ae57
Bigeye - Add support for deploying and removing custom SQL rules (#6379)
* Add support for defining custom SQL rules

* Added monitoring rollback command

* Reformat

* Add tests

* Address review feedback

* Add flags for deleting Bigeye checks

* Fix formatting

* Fix tests
2024-11-04 17:41:46 +00:00
Ben Wu 1e57300de4
Add time partitioning spec to mobile_search_clients_daily_historical_pre202408 (#6437) 2024-11-01 21:36:15 +00:00
Sean Rose 835081f55d
Add and update VPN VAT rates (DENG-2707) (#6423)
* Update existing VAT rates.

* Add new VAT rates.
2024-11-01 18:39:47 +00:00
Anna Scholtz 231c99d013
Specify partition column for Bigeye monitoring for ssl_ratios (#6436)
`ssl_ratios_v1` is actually a view (pointing to the public `ssl_ratios_v1` table), and Bigeye requires a partition column to be configured explicitly on views. This should fix the failing Airflow deployment task
2024-11-01 16:58:20 +00:00
dependabot[bot] 2a67a3a66f
Bump mkdocs-material from 9.5.42 to 9.5.43 (#6434)
Bumps [mkdocs-material](https://github.com/squidfunk/mkdocs-material) from 9.5.42 to 9.5.43.
- [Release notes](https://github.com/squidfunk/mkdocs-material/releases)
- [Changelog](https://github.com/squidfunk/mkdocs-material/blob/master/CHANGELOG)
- [Commits](https://github.com/squidfunk/mkdocs-material/compare/9.5.42...9.5.43)

---
updated-dependencies:
- dependency-name: mkdocs-material
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
2024-11-01 15:12:44 +00:00
dependabot[bot] cb72ce83bc
Bump google-cloud-datacatalog-lineage from 0.3.9 to 0.3.10 (#6435)
Bumps [google-cloud-datacatalog-lineage](https://github.com/googleapis/google-cloud-python) from 0.3.9 to 0.3.10.
- [Release notes](https://github.com/googleapis/google-cloud-python/releases)
- [Changelog](https://github.com/googleapis/google-cloud-python/blob/main/packages/google-cloud-documentai/CHANGELOG.md)
- [Commits](https://github.com/googleapis/google-cloud-python/compare/google-cloud-datacatalog-lineage-v0.3.9...google-cloud-datacatalog-lineage-v0.3.10)

---
updated-dependencies:
- dependency-name: google-cloud-datacatalog-lineage
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
2024-11-01 15:12:21 +00:00
Anna Scholtz c7521153be
CLI command to automate some migration of ETL checks to Bigeye (#6362)
* Add command to automate migration of ETL checks

* Migrate ETL checks for ssl_ratios

* Update bigconfigs
2024-11-01 12:27:57 +00:00
Sean Rose f8b7cfc11d
Remove duplicate currencies from `mozilla_vpn_derived.exchange_rates_v1` ETL config (DENG-5883). (#6433) 2024-10-31 23:59:30 +00:00
Sean Rose 059572df0c
Update `mozilla_vpn_derived.exchange_rates_v1` to include VPN wave 7 expansion country currencies (DENG-5883). (#6432) 2024-10-31 22:19:08 +00:00
Sean Rose 10f15c4fa4
Change Stripe tax transaction exchange rate to BIGNUMERIC type. (#6428)
Some historical Stripe tax transactions contain exchange rates with 16 digits after the decimal, which exceeds the normal NUMERIC type's maximum scale of 9 digits after the decimal.
2024-10-31 21:05:02 +00:00
Ben Wu 70b794b434
Populate empty query.py in stage deploy instead of CI config (#6430) 2024-10-31 20:50:22 +00:00
Alekhya 7f72235eb4
Switch to baseline beginning Aug 01st 2024 (#6425)
* 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
2024-10-31 19:11:36 +00:00
Anna Scholtz 381107db71
Revert #6418 (#6429) 2024-10-31 15:41:23 +00:00
Ben Wu 759cbe3231
Fix backfill validation tests in CI (#6398)
* Fix logging in backfill validation

* validate backfill should fail

* validate backfill should still fail

* revert entry, move validate-backfills to after generate-sql
2024-10-30 20:25:41 +00:00
Ben Wu b68db470bd
Sort query references result when parallelism > 0 (#6427) 2024-10-30 20:25:31 +00:00
Anna Scholtz 922f5ee70f
Fully-qualify INFORMATION_SCHEMA datasets in ./bqetl view clean (#6426) 2024-10-30 20:01:27 +00:00
Anna Scholtz d486bed1b9
Use INFORMATION_SCHEMA to get existing views for cleaning (#6424)
* Use INFORMATION_SCHEMA to get existing views for cleaning

* Update _list_managed_views caller
2024-10-30 18:32:01 +00:00
m-d-bowerman 44cb706ff7
remove provider- from engine strings (#6419) 2024-10-30 15:59:19 +00:00
Ben Wu 26adc67513
Fix materialized views failing stage deploy (#6421)
* Create test materialized view

* fix copy_sql_to_tmp_dir renaming

* Add materialized views to view dependencies

* remove test files
2024-10-30 15:33:28 +00:00
Alekhya ca17fa2e91
New view mobile search clients daily (#6370)
* Add new view for mobile_search_clients_daily

Delete sql/moz-fx-data-shared-prod/search_derived/mobile_search_clients_daily_v1/backfill.yaml

Fix format issue

* Update view.sql

* Fix query sql

Fix query.sql format

Fix query sql

* Add medata yaml file

* Fix metadata.yaml file issue

* Delete ]

* Update metadata.yaml

* Update metadata.yaml

* Update metadata.yaml

* Fix schema.yaml

* Fix file

* Fix deploy stage issues

* Fix sql

* Fix sql

* Fix metadata.yaml

---------

Co-authored-by: Alekhya <alekhya@Mac.lan>
2024-10-30 15:33:19 +00:00
Anna Scholtz 2add865249
Speed up schema updates (#6418)
* Parallelize dependency graph

* Use GCP API to get table schema when not using cloud function

* Reuse GCP credentials

* Update dependency tests

* Remove print
2024-10-30 14:52:05 +00:00
dependabot[bot] 5ce6152d0b
Bump siggen from 2.1.20240726 to 2.2.20241029 (#6420)
Bumps [siggen](https://github.com/willkg/socorro-siggen) from 2.1.20240726 to 2.2.20241029.
- [Changelog](https://github.com/willkg/socorro-siggen/blob/main/HISTORY.rst)
- [Commits](https://github.com/willkg/socorro-siggen/compare/v2.1.20240726...v2.2.20241029)

---
updated-dependencies:
- dependency-name: siggen
  dependency-type: direct:production
  update-type: version-update:semver-minor
...

Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
2024-10-30 14:49:29 +00:00
Ben Wu a270272b38
Add line to empty query.py in CI copy_debug_sql (#6417)
* Add line to empty query.py in CI copy_debug_sql

* ooooooop

* remove test file
2024-10-29 20:40:37 +00:00
Anna Scholtz 6c87dfb547
Reuse GCP API credentials for view updates (#6415)
* Reuse GCP API credentials for view updates

* isort
2024-10-29 15:31:29 +00:00
Anna Scholtz 35c92f086c
Filter overactive clients for `baseline_clients_daily` and `sponsored_tiles_clients_daily` (#6413)
* Filter overactive clients from baseline_clients_daily

* Filter overactive clients for sponsored_tiles_clients_daily

* Increase sponsored_tiles_clients_daily overactive threshold

* Update sql/moz-fx-data-shared-prod/telemetry_derived/sponsored_tiles_clients_daily_v1/query.sql

Co-authored-by: Ben Wu <12437227+BenWu@users.noreply.github.com>

---------

Co-authored-by: Ben Wu <12437227+BenWu@users.noreply.github.com>
2024-10-28 20:37:25 +00:00
m-d-bowerman af40ecf372
complete backfill (#6407) 2024-10-28 20:03:26 +00:00
Ben Wu 7386ab9574
[DENG-5931] Add partitioning to experiment_events_live_v1 (#6414) 2024-10-28 19:59:18 +00:00
Katie Windau a37c4c9088
Update to US only and last 28 days only (#6412) 2024-10-28 19:06:22 +00:00
Anna Scholtz 3b222a21e9
Parallelize metadata publish (#6403) 2024-10-28 19:03:08 +00:00
Anna Scholtz f8fa9ef3a4
Speed up view deploys by using processing pool (#6401) 2024-10-28 19:02:45 +00:00
Anna Scholtz 03e88b1875
Skip updating schemas of tables that are skipped for deploys (#6410) 2024-10-28 18:25:54 +00:00
Katie Windau 1963d52aa5
DENG-5757 add new summary view of metadata completeness by project/schema (#6411)
* DENG-5757 add new summary view of metadata completeness by project & dataset

* DENG-5757 add new summary view of metadata completeness by project & dataset
2024-10-28 18:18:30 +00:00
Ben Wu 7368691016
Use upstream main commit for CI sql diff (#6408)
* trivial sql diff

* Use latest upstream main commit for sql diff

* revert sql
2024-10-28 17:57:23 +00:00