Skip to content
Useful scripts, udfs, views, and other utilities for migration and data warehouse operations in BigQuery.
TSQL Shell
Branch: master
Clone or download
epishova and freedomofnet Changed repo description and added new functions (#18)
* Changed repo description since migration directory contains other databases besides Teradata

* Implementation of translate function

* Implementation of otranslate function

* The function parses Redshift interval literal and converts it to seconds

* Update README.md

* Update README.md

* Update README.md

* Update README.md

* Update README.md

* Update README.md

* Update README.md

* Formatted code with BQ UI

* Update README.md

* Update README.md

* Update README.md

* Changed code formatting

* Updated code formatting

* Update README.md

* Changed code formatting
Latest commit 62981c6 Nov 14, 2019

README.md

BigQuery Utils

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.

Open in Cloud Shell

Getting Started

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).

Public UDFs

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>().

Alt text

Contributing

See the contributing instructions to get started contributing.

License

All solutions within this repository are provided under the Apache 2.0 license. Please see the LICENSE file for more detailed terms and conditions.

Disclaimer

This repository and its contents are not an official Google Product.

You can’t perform that action at this time.