This template creates a BigQuery dataset and table.
- Install gcloud
- Create a GCP project, set up billing, enable requisite APIs
- Grant the
roles/bigquery.dataEditor
,roles/bigquery.dataOwner
orroles/bigquery.admin
IAM roles to the project service account
See the properties
section in the schema file(s)
- Clone the Deployment Manager Samples repository
git clone https://github.com/GoogleCloudPlatform/cloud-foundation-toolkit
- Go to the dm directory
cd dm
- Copy the example DM config to be used as a model for the deployment, in this case examples/bigquery.yaml
cp templates/bigquery/examples/bigquery.yaml my_bigquery.yaml
- Change the values in the config file to match your specific GCP setup. Refer to the properties in the schema files described above.
vim my_bigquery.yaml # <== change values to match your GCP setup
- Create your deployment as described below, replacing <YOUR_DEPLOYMENT_NAME> with your with your own deployment name
gcloud deployment-manager deployments create <YOUR_DEPLOYMENT_NAME> \
--config my_bigquery.yaml
- In case you need to delete your deployment:
gcloud deployment-manager deployments delete <YOUR_DEPLOYMENT_NAME>