looker-studio-bigquerylisted

# Looker Studio BigQuery Integration ## When to use this skill - **Analytics dashboard creation**: Visualizing BigQuery data to derive business insights - **Real-time reporting**: Building auto-refreshing dashboards - **Performance optimization**: Optimizing query costs and loading time for large datasets - **Data pipeline**: Automating ETL processes with scheduled queries - **Team collaboration**: Building shareable interactive dashboards ## Instructions ### Step 1: Prepare GCP BigQuery Environment **Project creation and activation** Create a new project in Google Cloud Console and enable the BigQuery API. ```bash # Create project using gcloud CLI gcloud projects create my-analytics-project gcloud config set project my-analytics-project gcloud services enable bigquery.googleapis.com ``` **Create dataset and table** ```sql -- Create dataset CREATE SCHEMA `my-project.analytics_dataset` OPTIONS( description="Analytics dataset", location="US" ); -- Create example table (GA4 data) CREATE TABLE `my-project.analytics_dataset.events` ( event_date DATE, event_name STRING, user_id INT64, event_value FLOAT64, event_timestamp TIMESTAMP, geo_country STRING, device_category STRING ); ``` **IAM permission configuration** Grant IAM permissions so Looker Studio can access BigQuery: | Role | Description | |------|------| | `BigQuery Data Viewer` | Table read permission | | `BigQuery User` | Query execution permission | | `BigQuery Job User` | Job executi