search

populationgenomics / cpg-infrastructure

This repository is used to manage the infrastructure at the CPG
MIT License
3 stars 1 forks source link

Trying to fix BQ materialize view schema update. #222

Closed milo-hyben closed 7 months ago

milo-hyben commented 7 months ago

Pulumi / GCP does not support schema update for BQ materialised views. The only way is to delete and recreate the view. Problem start when MV is created without 'deletion_protection=False'. Basically Pulumi can not delete the view so update would cause en error. Removing the view does not work either. A bit of catch 22. This PR is trying to roll back original schema with 'deletion_protection=False'.

codecov-commenter commented 7 months ago

Codecov Report

All modified and coverable lines are covered by tests :white_check_mark:

:exclamation: No coverage uploaded for pull request base (main@0b319f5). Click here to learn what that means.

Additional details and impacted files ```diff @@ Coverage Diff @@ ## main #222 +/- ## ======================================= Coverage ? 90.65% ======================================= Files ? 4 Lines ? 428 Branches ? 0 ======================================= Hits ? 388 Misses ? 40 Partials ? 0 ```

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.