* 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
* 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>
* 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>