BigQuery Query

Rules: Follow coding-standards for SQL naming and readability.

Prerequisites

Check gcloud configuration before running queries:

gcloud config get-value project

• If authentication error: prompt user to run gcloud auth login, then resume
• If project unset: prompt user to run gcloud config set project <PROJECT_ID>

Workflow

1. Clarify requirements: Understand what data is needed and why. If requirements are already in context, proceed to next step.