BigQuery views from local repositors to BQ
Budget: €30 – €250 EUR
Hello,
we create a two folders locally (views and internal folders in one main folder) add all .sql files related to views and internal.. Now, we have to stack up one each other and put them on git and have the option to version them.
Now, we use these sql files in git repo to be imported in scripts and script take care of pushing in BQ. Like script (.sh) should not contain view code but it should contain that looks up the local sql file that we have in the git repo, loops thru them and push them to BQ. So the source files in our repo not on BQ anymore.
we create a two folders locally (views and internal folders in one main folder) add all .sql files related to views and internal.. Now, we have to stack up one each other and put them on git and have the option to version them.
Now, we use these sql files in git repo to be imported in scripts and script take care of pushing in BQ. Like script (.sh) should not contain view code but it should contain that looks up the local sql file that we have in the git repo, loops thru them and push them to BQ. So the source files in our repo not on BQ anymore.