GoogleCloudPlatform/bigquery-utils
Useful scripts, udfs, views, and other utilities for migration and data warehouse operations in BigQuery. observed · 2026-08-28
Health v2 · maintenance only
73/100
- Activity 90
- Release rhythm 35
- Longevity 100
Flags: no_releases
How is this computed?
round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10) — computed 2026-09-03. Adoption (stars, forks) is never an input.
- gap_med: n/a
- age_days: 2578
- days_rel: n/a
- days_push: 62
- n_releases_24m: 0
Adoption not part of the score
1306 stars · 335 forks observed · 2026-08-28
What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded
A Google-maintained collection of utilities for BigQuery, including SQL user-defined functions, stored procedures, views, Python and shell scripts, Looker Studio dashboards, and Colab notebooks. Its focus is on migrating from legacy data warehouses (Oracle, Netezza, Redshift, Snowflake) and on day-to-day data warehouse operations such as billing analysis and query optimization.
Use cases
- migrate oracle or snowflake sql functions to bigquery
- analyze gcp billing export data in bigquery
- monitor bigquery slot utilization and job errors
- find optimization opportunities in my bigquery warehouse
- compute distinct counts and quantiles with datasketches in bigquery
- build dashboards over bigquery information_schema metadata
- performance test bigquery with jmeter
When to choose
- You are migrating a data warehouse from Oracle, Netezza, Redshift, or Snowflake to BigQuery and need UDFs that mimic proprietary functions
- You want ready-made dashboards, scripts, and queries for BigQuery cost analysis, slot utilization, and job monitoring
- You need reusable SQL utilities, stored procedures, and automation examples for BigQuery maintained by Google
When to avoid
- You need a programmatic client SDK to run BigQuery jobs from application code - use the official BigQuery client libraries instead
- You use a data warehouse other than BigQuery, since the utilities are BigQuery-specific
- You need a general-purpose ETL or orchestration platform rather than SQL-centric utilities
Facets
library · maturity active
database analytics monitoring data-science databases big-data analytics cloud-computing developer-tools cloud python cli bigquery sql udf data-warehouse google-cloud-platform warehouse-migration looker-studio-dashboards datasketches stored-procedures cost-optimization information-schema data-engineering
2 sources
- readme: https://github.com/GoogleCloudPlatform/bigquery-utils · fetched 2026-08-28 · 2c9bdda6562e
- homepage: https://cloud.google.com/bigquery/ · fetched 2026-08-29 · fd3d4f27007c
Member repositories
| Repository | Role | Health v2 |
|---|---|---|
| GoogleCloudPlatform/bigquery-utils | main | 73 |
For agents
markdown · JSON · MCP: product_card(name="GoogleCloudPlatform/bigquery-utils")
Data as of 2026-08-30T08:39:29.467469+00:00 · Report a problem