bigquery-utils icon indicating copy to clipboard operation
bigquery-utils copied to clipboard

Useful scripts, udfs, views, and other utilities for migration and data warehouse operations in BigQuery.

Results 79 bigquery-utils issues
Sort by recently updated
recently updated
newest added

I can successfully use the protobuf exporter tool for protobuf message types containing one or more primitive data types. However, when I compile a message type with nested definitions (i.e....

Hello, I have generated the theta_sketch.mjs file using `make` command and used the following script to create theta_sketch_int64 UDF. https://github.com/GoogleCloudPlatform/bigquery-utils/blob/master/udfs/community/theta_sketch_int64.sqlx However, I am getting the following error while invoking the...

bug

Bumps org.apache.avro:avro from 1.11.3 to 1.11.4. [![Dependabot compatibility score](https://dependabot-badges.githubapp.com/badges/compatibility_score?dependency-name=org.apache.avro:avro&package-manager=maven&previous-version=1.11.3&new-version=1.11.4)](https://docs.github.com/en/github/managing-security-vulnerabilities/about-dependabot-security-updates#about-compatibility-scores) Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a...

dependencies
java

closes #459 It can be more cost efficient to use either the on-demand or the reservation compute billing model depending on query patterns. This script aims to identify projects that...

Some workloads are more cost efficient in one model or the other. - Analyzing on-demand -> reservation can be calculated by (tb_billed * on_demand_rate). Comparing this value to purely autoscaling...

enhancement

native parse_timestamp function parses fraction seconds as part of second using formt `E#S`. But other dialects like oracle sql could parse fraction second independently as `F`. So we need this...

The function deployment needs connections ${BQ_LOCATION}.multimodal-udf-connection to be created, which is used for Python udf to access networks. The connections need to be shared publicly for callers to use. No...