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

258 Коммитов

Автор SHA1 Сообщение Дата
Ben Wu 70b794b434
Populate empty query.py in stage deploy instead of CI config (#6430) 2024-10-31 20:50:22 +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 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
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
Curtis Morales 5f7ce6ce0a
Add more memory for private-generate-sql task (#6342) 2024-10-11 21:04:14 +00:00
Curtis Morales 102669a6a4
Extend timeout for no output for private-generate-sql step (#6336) 2024-10-11 15:59:25 +00:00
kik-kik 4257698cc8
feat(DENG-4602): add BigEye RunMetricOperator to DAG generation (#6285)
* 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>
2024-10-03 15:13:27 +00:00
Anna Scholtz 13349e8589
Generate Bigeye monitoring configs in CI (#6194)
* Generate Bigeye monitoring configs in CI

* Ensure Bigconfig files are loaded exactly once

* Avoid duplicate validation of Bigconfig files

* Authentication using API key to Bigeye

* Remove api-key option for Bigeye and rely on env var instead
2024-09-17 16:15:20 +00:00
Corban Cloud a26ce8b19e
DSRE-1683: Enables OIDC for GCR Artifact Push (#6178)
* Add tested context to private GCR, add OIDC flag

* upgrade orbs
2024-09-11 16:18:05 -07:00
Sean Rose e5df41e602
Upgrade the CircleCI Docker orb to v2.6. (#6126)
The `docker/machine` executor from v2.2 of that orb was using a deprecated Ubuntu 20.04 image that CircleCI will remove on 2024-09-30.
2024-08-28 12:08:56 -07:00
Sean Rose ad7572e5ca
Update CircleCI config to use latest Ubuntu 20.04 executor image. (#6122)
The previously used Ubuntu 20.04 executor image has been deprecated and will be removed on 2024-09-30.
2024-08-28 10:21:21 -07:00
Anna Scholtz d077ea046e
Limit the projects scanned for routines (#6101) 2024-08-26 15:28:49 -07:00
whd 345ed707dc
chore(ci): stop publishing to dockerhub (#5137) 2024-08-22 19:57:02 +00:00
Anna Scholtz 7024b6976e
Pass ID token to dryrun instances to speed things up (#6019)
* Pass ID token to dryrun instances to speed things up

* Parallelize metadata and dependency generation

* Use table schema from dryrun function
2024-08-08 12:38:43 -07:00
Mikaël Ducharme 190314fc55
chore(ci): Use WIP circleci context for OIDC. (#5855) 2024-06-28 12:20:45 -04:00
Anna Scholtz 57bd939905
Fully qualified identifiers in SQL queries (#5764)
* 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
2024-06-27 09:53:33 -07:00
Anna Scholtz 99ffb65f60
Explicitly specify dag_id in CI for artifact deployment (#5847) 2024-06-26 09:48:42 -07:00
Sean Rose 92a8dba70e
Have CI run SQL generation if files in `sql/` were renamed. (#5823) 2024-06-21 09:03:25 -07:00
Mikaël Ducharme 044702503f
feat(ci): Use CircleCI OIDC for artifact deployment. (#5291) 2024-06-13 16:06:40 -04:00
Anna Scholtz 682dcfc682
Fix PyPI package publishing in CI (#5669)
* Fix PyPI package publishing in CI

* Update .circleci/workflows.yml

Co-authored-by: Mike Williams <102263964+mikewilli@users.noreply.github.com>

---------

Co-authored-by: Mike Williams <102263964+mikewilli@users.noreply.github.com>
2024-05-28 14:03:06 -07:00
Sean Rose 18f283949e
Fix link to full `sql.diff` file (#5620)
* Run `post-diff.js` in the same CI job that uploads `sql.diff` as a CI artifact.

This is necessary for `post-diff.js` to get the correct CI job ID to use in the link to download the full `sql.diff` file.

* Only show link to full `sql.diff` file if it has content.

* Change the path `sql.diff` is stored at so the same `post-diff.js` script can used for both `bigquery-etl` and `private-bigquery-etl`.
2024-05-20 13:15:26 -07:00
Sean Rose 911c770a04
Store debug artifacs when CI jobs downstream of SQL generation fail. (#5489) 2024-05-03 09:58:11 -07:00
Sean Rose a7c06240a6
Fix `test-sql` CI job to only store artifacts when the job fails. (#5457)
It turns out the `when:` conditional parameter is only valid for `run` steps.
2024-04-30 10:43:37 -07:00
Sean Rose dc36e1887c
Store artifacts when `deploy-changes-to-stage` CI job fails for troubleshooting (#5454) 2024-04-29 17:14:42 -07:00
Sean Rose 29c0849af3
Store artifacts when `test-sql` CI job fails for troubleshooting. (#5451) 2024-04-29 10:19:22 -05:00
Anna Scholtz 31c31de0ea
Have Jinja in generated SQL (#5249)
* Have Jinja in generated SQL

* [run-tests] Speed up stage deploys

* Fix stage tests

* Use is_init() when updating schemas for undeployed tables
2024-04-02 10:40:02 -07:00
Anna Scholtz 366ec35508
Fix dry-run CI when skipping stage deploys (#5240) 2024-03-20 11:18:02 -07:00
Anna Scholtz 54dcb424ac
Remove skipping DAG validation in CI (#5238) 2024-03-19 12:57:49 -07:00
Anna Scholtz a6cb933ef1
CircleCI continuation for tags (#5216) 2024-03-14 14:47:10 -07:00
Anna Scholtz 161bab4161
Separate CI workflow for pushing packages to pypi (#5214) 2024-03-14 13:03:25 -07:00
kik-kik bc8ddd3582
feat(): Upgrade BQETL Python to 3.11 and pre-commit hooks (#5195)
* upgrade pre-commit hooks

* Upgrade Python to 3.11
2024-03-14 14:25:30 +01:00
kik-kik fdf78c58ab
Upgrade Python used for validate-dags step to match telemetry-airflow (#5202) 2024-03-14 11:59:34 +01:00
Anna Scholtz 95f26f86ed
Revert "Revert "feat(ci): Add artifact-deployment to CircleCI workflows"" (#5188)
* Revert "Revert "feat(ci): Add artifact-deployment to CircleCI workflows (#513…"

This reverts commit f62e26e99d.

* Update .circleci/workflows.yml
2024-03-11 11:37:02 -07:00
Anna Scholtz d453a77094
Sync submodules sequentially (#5187) 2024-03-08 09:16:14 -08:00
Anna Scholtz 70a355a0dd
Require authentication for dry run function and run gcloud auth when … (#5171)
* Require authentication for dry run function and run gcloud auth when not logged in

* authenticate step in CI, remove interactive gcloud auth

* Skip dryrun for ltv_state_values_v2

* Refactor skip_fork in CI, clarify login requirements
2024-03-06 15:06:29 -08:00
Anna Scholtz f62e26e99d
Revert "feat(ci): Add artifact-deployment to CircleCI workflows (#5136)" (#5146)
This reverts commit 8b1e965303.
2024-03-01 08:50:13 -08:00
Mikaël Ducharme 8b1e965303
feat(ci): Add artifact-deployment to CircleCI workflows (#5136) 2024-02-28 16:50:05 -05:00
Anna Scholtz 7d28bb1785
Fix validate-routine CI (#5115) 2024-02-26 09:59:47 -08:00
Anna Scholtz 41e953ea20
Conditional steps in CI (#5095)
* Revert "Revert "Path Filtering in CI (#4939)""

This reverts commit d6189a7641.

* Revert "Revert "Run SQL checks when requirements change (#5030)""

This reverts commit 3991a2574b.

* Revert "Revert "Add parameter to skip stage depoys in CI (#5035)""

This reverts commit c4c651d0c5.

* run-all CI workflow

* Use conditionals in jobs

* Add deploy parameter and use yaml references for conditions

* Add backfill validation
2024-02-26 09:36:53 -08:00
Winnie Chan 2387660ab7
DENG-822: Validate workgroups in backfills (#5081)
* Updated workgroup validations

* Fixed indentation in config.yml

* removed sys exit

Co-authored-by: Alexander <anicholson@mozilla.com>

* raise value error

Co-authored-by: Alexander <anicholson@mozilla.com>

* added workgroup constant

* Fixed value error

---------

Co-authored-by: Alexander <anicholson@mozilla.com>
2024-02-23 12:54:38 -08:00
Arkadiusz Komarzewski d6189a7641 Revert "Path Filtering in CI (#4939)"
This reverts commit bff0a754d4.
2024-02-15 16:34:37 +01:00
Arkadiusz Komarzewski 3991a2574b Revert "Run SQL checks when requirements change (#5030)"
This reverts commit d3f3c84295.
2024-02-15 16:34:37 +01:00
Arkadiusz Komarzewski c4c651d0c5 Revert "Add parameter to skip stage depoys in CI (#5035)"
This reverts commit 94a4a10407.
2024-02-15 16:34:37 +01:00
Anna Scholtz 94a4a10407
Add parameter to skip stage depoys in CI (#5035) 2024-02-13 12:53:03 -08:00
Anna Scholtz d3f3c84295
Run SQL checks when requirements change (#5030) 2024-02-13 10:58:15 -08:00
Anna Scholtz bff0a754d4
Path Filtering in CI (#4939)
* Path Filtering in CI

* generated-sql updates

* CI filtering for UDF changes

* Make change to tooling
2024-02-12 14:17:53 -08:00
whd c05ac1d661
Stop using data-eng-circleci-tests context in CI (#4884) 2024-02-08 21:35:55 +00:00
Anna Scholtz 0b8e8f14a4
Push tags for commits on generated-sql branch (#4984)
* Push tags for commits on generated-sql branch

* Update .circleci/config.yml

Co-authored-by: Alexander <anicholson@mozilla.com>

---------

Co-authored-by: Alexander <anicholson@mozilla.com>
2024-02-07 11:07:32 -08:00
Anna Scholtz e10b93c06c
fix typo in CI (#4983)
Typo in circleci
2024-02-07 10:08:56 -08:00
Anna Scholtz fa1c2492bd
Use caching in generate-sql (#4953)
* Use caching in generate-sql

* Make change in sql generator

* Remove file

* Add CI comments
2024-02-07 08:57:05 -08:00