CODEWITHSUNDEEP
google-bigquery
Maulik Modi
Maulik Modi

Reputation: 303

Deployment Automation in Bigquery

I am using Bigquery for the past 3-6 months and we have created several datastudio reports and now we are looking for ways to keep things in source control and automate deployment.

While using SQL server as RDBMS, we used SQL Server database project that allows keeping initial schema/data or migrations in source control and pushed them to target environment.What are our options to do something similar in Bigquery?

Upvotes: 0

Views: 1262

Answers (1)

Amruth Bahadursha
Amruth Bahadursha

Reputation: 74

You can use the Cloud Source Repositories to source control for an application or service. You can use this repository to multiple private repositories and organize the code associated with your cloud project. If you have setup the Cloud Source Repository, you can use the deployment guide provided here. If you want to load data into BigQuery, follow the guide provided here. You can also use an Avro data, where the data and schema is stored in the same file. When you load Avro data from Cloud Storage, you have the option to create a new table or partition, append or overwrite to an existing table. You can use Cloud Container Builder to redeploy your cloud functions automatically from a source repository such as Cloud Source repositories.

Upvotes: 1

Related Questions