git:20260211.af4d63f to git:20260306.b04d94a

---

name: looker-studio-bigquery

description: Design and configure Looker Studio dashboards with BigQuery data sources. Use when creating analytics dashboards, connecting BigQuery to visualization tools, or optimizing data pipeline performance. Handles BigQuery connections, custom SQL queries, scheduled queries, dashboard design, and performance optimization.

---

# Looker Studio BigQuery Integration

## When to use this skill

## Instructions

```bash

gcloud projects create my-analytics-project

gcloud config set project my-analytics-project

gcloud services enable bigquery.googleapis.com

```

```sql

CREATE SCHEMA `my-project.analytics_dataset`

OPTIONS(

location="US"

);

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

);

```

|------|------|

```sql

SELECT

event_date,

event_name,

COUNT(DISTINCT user_id) as unique_users,

SUM(event_value) as total_revenue,

AVG(event_value) as avg_revenue_per_event

FROM `my-project.analytics_dataset.events`

WHERE event_date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)

GROUP BY event_date, event_name

ORDER BY event_date DESC

```

```sql

SELECT

e.event_date,

e.event_name,

u.user_country,

u.user_tier,

COUNT(DISTINCT e.user_id) as unique_users,

SUM(e.event_value) as revenue

FROM `my-project.analytics_dataset.events` e

LEFT JOIN `my-project.analytics_dataset.users` u

ON e.user_id = u.user_id

WHERE e.event_date >= DATE_SUB(CURRENT_DATE(), INTERVAL 90 DAY)

GROUP BY e.event_date, e.event_name, u.user_country, u.user_tier

```

```sql

CREATE OR REPLACE TABLE `my-project.analytics_dataset.daily_summary` AS

SELECT

CURRENT_DATE() as report_date,

event_name,

user_country,

COUNT(DISTINCT user_id) as daily_users,

SUM(event_value) as daily_revenue,

AVG(event_value) as avg_event_value,

MAX(event_timestamp) as last_event_time

FROM `my-project.analytics_dataset.events`

WHERE event_date = CURRENT_DATE() - 1

GROUP BY event_name, user_country

```

```

┌─────────────────────────────────────┐

├─────────────────────────────────────┤

├─────────────────────────────────────┤

│ │

│ │

├─────────────────────────────────────┤

├─────────────────────────────────────┤

└─────────────────────────────────────┘

```

```

┌──────────────────────────────────────────────────┐

├──────────────────────────────────────────────────┤

├──────────────────────────────────────────────────┤

├──────────────────────────────────────────────────┤

├──────────────────────────────────────────────────┤

└──────────────────────────────────────────────────┘

```

```

```

```sql

WHERE customer_revenue >= 10000

```

```sql

event_date >= DATE_SUB(CURRENT_DATE(), INTERVAL @date_range_days DAY)

WHERE country = @selected_country

WHERE event_date >= @start_date

AND event_date <= @end_date

AND country IN (@country_list)

AND revenue >= @min_revenue

```

```sql

SELECT * FROM events

WHERE DATE(event_timestamp) >= '2026-01-01'

SELECT * FROM events

```

```sql

CREATE OR REPLACE TABLE `my-project.looker_studio_data.dashboard_snapshot` AS

SELECT

event_date,

event_name,

country,

device_category,

COUNT(DISTINCT user_id) as users,

SUM(event_value) as revenue,

COUNT(*) as events

FROM `my-project.analytics_dataset.events`

WHERE event_date >= DATE_SUB(CURRENT_DATE(), INTERVAL 90 DAY)

GROUP BY event_date, event_name, country, device_category;

```

```javascript

function getConfig() {

return {

configParams: [

{

name: 'project_id',

displayName: 'BigQuery Project ID',

helpText: 'Your GCP Project ID',

placeholder: 'my-project-id'

},

{

name: 'dataset_id',

displayName: 'Dataset ID'

}

]

};

}

function getData(request) {

const projectId = request.configParams.project_id;

const datasetId = request.configParams.dataset_id;

const bq = BigQuery.newDataset(projectId, datasetId);

return { rows: data };

}

```

```sql

GRANT `roles/bigquery.dataViewer`

ON TABLE `my-project.analytics_dataset.events`

TO "user@example.com";

CREATE OR REPLACE ROW ACCESS POLICY rls_by_country

ON `my-project.analytics_dataset.events`

GRANT ('editor@company.com') TO ('KR'),

('viewer@company.com') TO ('US', 'JP');

```

## Output format

```markdown

## Dashboard Setup Checklist

```

## Constraints

## Best practices

|------|---------|

## References

- [Looker Studio Help](https://support.google.com/looker-studio)

- [BigQuery Documentation](https://cloud.google.com/bigquery/docs)

- [Connect to BigQuery](https://cloud.google.com/looker/docs/studio/connect-to-google-bigquery)

- [Community Connectors](https://developers.google.com/looker-studio/connector)

- [Dashboard Design Best Practices](https://lookercourses.com/dashboard-design-tips-for-looker-studio-how-to-build-clear-effective-reports/)

## Metadata

`#Looker-Studio` `#BigQuery` `#dashboard` `#analytics` `#visualization` `#GCP`

## Examples

```sql

CREATE OR REPLACE TABLE `my-project.looker_data.daily_metrics` AS

SELECT

event_date,

COUNT(DISTINCT user_id) as dau,

SUM(revenue) as total_revenue,

COUNT(*) as total_events

FROM `my-project.analytics.events`

WHERE event_date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)

GROUP BY event_date;

```

```sql

CREATE OR REPLACE TABLE `my-project.looker_data.cohort_analysis` AS

WITH user_cohort AS (

SELECT

user_id,

DATE_TRUNC(MIN(event_date), WEEK) as cohort_week

FROM `my-project.analytics.events`

GROUP BY user_id

)

SELECT

uc.cohort_week,

DATE_DIFF(e.event_date, uc.cohort_week, WEEK) as week_number,

COUNT(DISTINCT e.user_id) as active_users

FROM `my-project.analytics.events` e

JOIN user_cohort uc ON e.user_id = uc.user_id

GROUP BY cohort_week, week_number

ORDER BY cohort_week, week_number;

```