BigQuery is a fully managed, petabyte-scale, and cost-effective analytics data warehouse that lets you run analytics over vast amounts of data in near real time. For more information, see BigQuery introduction .
This document describes the components and parameters you can configure when using App Design Center to create a BigQuery dataset. The configuration parameters are based on the terraform-google-bigquery Terraform module.
Component connections
The following table includes the components that you can connect to a BigQuery dataset, and the resulting updates to your application and its generated Terraform code.
Connected component
Application updates
Background information
- The Compute Engine instances can read and write data to the BigQuery dataset.
- The BigQuery resource metadata is added to the Compute Engine instance template.
- The
roles/bigquery.dataEditorrole is added to Compute Engine instance template service account.
- The service account can be used by services, such as Cloud Run, to read and modify data in the BigQuery dataset.
- The BigQuery
roles/bigquery.dataEditorrole is added to the service account.
- The Cloud Run service can interact with the BigQuery dataset.
- The BigQuery resource metadata is added to the Cloud Run environment variables.
- The BigQuery
roles/bigquery.dataEditorrole is added to the Cloud Run service account.
- The Pub/Sub subscription can write messages to the BigQuery dataset.
- The BigQuery dataset information is added to the BigQuery subscription fields.
Required configuration parameters
If your template includes a BigQuery component, you must configure the following parameters before you deploy.
| Parameter name |
Description and constraints |
Background information |
|---|---|---|
| Dataset ID |
id | Introduction to datasets |
| Project ID |
The project where you want to deploy the BigQuery dataset and table. |
Configure components |
Optional configuration parameters
The following parameters are optional. To display advanced parameters, in the Configurationarea, select Show advanced fields.
Feature
Subfeature
Parameter name
Description and constraint information
Background information
Deletion Protection
Select the checkbox to prevent this table from being deleted by Terraform. If not selected, the component-level Deletion Protection setting is used.
Delete Contents on Destroy
Select to delete all tables in the dataset when destroying the resource. If not selected, destroying the resource fails if tables are present.
Deletion Protection
When selected, a terraform apply or terraform destroy that would delete tables will fail. When not selected, tables can be deleted. You can override this setting using the deletion protection setting for each table.
Default Partition Expiration MS
Ignore Unknown Values
Deletion Protection
Select the checkbox to prevent this table from being deleted by Terraform. If not selected, the component-level Deletion Protection setting is used.
