BigQuery is a serverless, highly-scalable, and cost-effective cloud data warehouse with an in-memory BI Engine and machine learning built in. This repository provides useful utilities to assist you in migration and usage of BigQuery.
This repository is broken up into:
- Scripts - Python, Shell, & SQL scripts
- billing - Example queries over the GCP billing export
- UDFs - User-defined functions for common usage as well as migration
- Views - Views over system tables such as audit logs or the
INFORMATION_SCHEMA
- query_audit - View to simplify querying the audit logs which can be used to power dashboards (example).
All UDFs within this repository will be automatically created under the bqutil
project under publicly shared datasets. Queries can then reference the shared UDFs via bqutil.<dataset>.<function>()
.
See the contributing instructions to get started contributing.
All solutions within this repository are provided under the Apache 2.0 license. Please see the LICENSE file for more detailed terms and conditions.
This repository and its contents are not an official Google Product.