[GCP] How To Export Billing To BigQuery And Show Into LookerStudio

Step 1

Make Sure Your Billing Data Export To BigQuery

Verify From BigQuery

Step 2

Deploy From Cloud Shell

Clone TF Code From Git

Create Variable File

cat << EOF > variables.tfvars
 project-id = "PROJECT_ID"
 bq-dashboard-dataset-name = "DATASET_NAME"
 bq-billing-export-table-id = "PROJECT_ID.DATASET_NAME.TABLE_ID"
 looker-studio-service-agent-name = "LOOKER_STUDIO_AGENT_NAME"
EOF

Information For Variables

LOOKER_STUDIO_AGENT_NAME Need Go To Here To Get

Init Terraform

terrafrom init

Deploy Terraform

terraform apply -var-file=variables.tfvars

View Dashboard From Looker Studio