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 or roles/bigquery.admin IAM roles to the project service account

• bigquery.v2.dataset
• bigquery.v2.tables

See the properties section in the schema file(s)

• BigQuery Dataset
• BigQuery Tables

1. Clone the Deployment Manager Samples repository

    git clone https://github.com/GoogleCloudPlatform/cloud-foundation-toolkit

2. Go to the dm directory

    cd dm

3. 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

4. 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

5. 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

6. In case you need to delete your deployment:

    gcloud deployment-manager deployments delete <YOUR_DEPLOYMENT_NAME>

• Bigquery Dataset and Table