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

15 Коммитов

Автор SHA1 Сообщение Дата
Leli bde2c50acd
improve is_unique data check message (#5125) 2024-02-27 21:00:11 +01:00
m-d-bowerman 82fc3d0743
Adds absolute value to check for unreasonable increase (#4998) 2024-02-09 08:02:49 -08:00
kik-kik f0f64ae1ad
bug(1870691): fixed spelling mistake and added missing filter for focus android check (#4726)
* fixed spelling mistake and added missing filter for focus android check

* Formatting

---------

Co-authored-by: Alexander Nicholson <anicholson@mozilla.com>
2023-12-22 10:54:35 -05:00
kik-kik 85216b9c2a
added an option to matches_pattern to be able to specify percentage threshold / tolerance for failures for the check (#4716) 2023-12-15 15:44:49 +01:00
Leli 699b325a0e
add accepted values check (#4650)
* add accepted values check

* added semicolon
2023-12-15 13:34:04 +01:00
kik-kik 34d6a463dc
feat(DENG-2175): added matches_pattern etl checks macro and updated tests to use it (#4683)
* added matches_pattern etl checks macro and updated tests to use it

* added matches_pattern etl check macro to the data checks docs
2023-12-13 16:10:34 +01:00
kik-kik 2db2f3e2de
feat(DENG-2156): added value_length check and updated some of the ETL checks to use the macro (#4672)
* added value_length check and updated some of the ETL checks to use the macro

* added the new check macro to the data checks docs

* implemented lelilia feedback from PR#4672

* simplified the sql logic for the value_length check
2023-12-11 16:31:25 +01:00
Leli f84a097524
Feat/deng 2046/migrating telemetry derived active users aggregates v1 dim checks to etl checks (#4641)
* Migrated DIM checks over to ETL checks for telemetry_derived.active_users_aggregates_v1

* rewrite

* code review suggestions

* add doc

* rename

---------

Co-authored-by: kik-kik <kignasiak@mozilla.com>
2023-12-04 17:19:48 +01:00
Frank Bertsch c21cca68ab
Update min_row_count error text (#4586) 2023-11-20 14:27:17 -05:00
m-d-bowerman d77a86182d
Add a period-over-period check for revenue data (#4566)
* Check for period over period changes in column sum

* Fix percent change calculation

* Fix errors in navigation function logic

* Rename period over period check to specify revenue

* Remove references to period over period check

---------

Co-authored-by: Alekhya <88394696+alekhyamoz@users.noreply.github.com>
2023-11-15 06:11:24 -08:00
Alekhya 01ff67a29f
Rename min_rows check macro to min_row_count (#4301) 2023-09-14 15:06:41 -04:00
kik-kik c6f517d5d2
tweaking the min_rows data check macro as currently not erroring when should (#4254) 2023-09-07 17:54:32 +02:00
Sean Rose 8e751a26da
Allow bqetl checks that take a list of columns to also accept a single column string. (#4207) 2023-08-18 11:43:09 -07:00
kik-kik b927ed22be
feat(DENG-949): Added `render` subcommand and `--dry-run` flag to the bqetl check command (#4045)
* added render subcommand to the bqetl check command

* added a dry_run flag to bqqetl check run command

* added a test to make sure run command exists with status code 0

* added test for check render subcommand

* fixing linter checks

* attempting using an alternative way of testing the render command

* fixing render test by testing the _render() directly rather than the render cli wrapper

* removed dead test

* Apply suggestions from code review by ascholtz

Co-authored-by: Anna Scholtz <anna@scholtzan.net>

* fixed black and mypy errors

* fixed app_store_funnel_v1 check formatting

* reformatted tests checks

---------

Co-authored-by: Anna Scholtz <anna@scholtzan.net>
2023-08-09 16:39:47 +02:00
Anna Scholtz dc482ad8d5
[DENG-948] Macro support for data checks (#3993)
* Add support for check macros

* Add min_rows() check macro

* Add is_unique() check macro

* Add in_range() check macro

* Update ssl_ratios DAG

* Add test for macro checks

* Fix rendering
2023-07-06 14:36:59 -07:00