Bigquery中的部署自动化 [英] Deployment Automation in Bigquery

问题描述

过去3到6个月我一直在使用Bigquery，我们已经创建了多个datastudio报告，现在我们正在寻找将内容保持在源代码控制和自动化部署中的方法.

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.

使用SQL Server作为RDBMS时，我们使用

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?

推荐答案

您可以使用云源存储库，用于对应用程序或服务进行源代码控制.您可以将此存储库用于多个私有存储库，并组织与您的云项目关联的代码.如果您已经设置了Cloud Source Repository，则可以使用此处提供的部署指南>.如果要将数据加载到BigQuery中，请此处一个>.您还可以使用Avro数据，其中数据和架构存储在同一文件中.当您从Cloud Storage加载Avro数据时，您可以选择创建新表或分区，追加或覆盖现有表.您可以使用Cloud Container Builder从服务器上自动重新部署云功能源存储库，例如Cloud Source存储库.

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.

这篇关于Bigquery中的部署自动化的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！