bigquery-utils
bigquery-utils copied to clipboard
Useful scripts, udfs, views, and other utilities for migration and data warehouse operations in BigQuery.
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...
Bumps org.apache.avro:avro from 1.11.3 to 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...
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...
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...