bigquery-utils

bigquery-utils copied to clipboard

Update typeof. Support of single quoted JSON

1

This fix is adding support for single-quoted JSON. Currently, it works only with double-quoted JSON. There is no way to check JSON containing strings, dictionaries and lists. This works: SELECT...

tartas1

Adding the possibility of differentiating resource-based CUDs from spend-based CUDs. Also removed the filter to take information only from the "Compute Engine" service, making the query efficient for all new...

Bento-87

Hi, #252 asked for the community UDFs to be made available in regions other than the US - I'm unable to find them. I searched for bqutil in the BigQuery...

brabster

Bug: Jaccard UDF giving incorrect results in some cases

1

I found a bug in the the Jaccard distance function https://github.com/GoogleCloudPlatform/bigquery-utils/blob/master/udfs/community/jaccard.sqlx (the function below is a copy of the Jaccard UDF, cast as a TEMP FUNCTION) ``` CREATE TEMP FUNCTION...

j-svensmark

I often implement BigQuery SQL for Google Analytics 4. And these UDFs are very helpful in that implementation. However, the inability to cross regions within a single query and the...

ryota-yamada-jp

Missing Datasource for Hourly Utilization Heatmap section

1

I see that recently a **"Average Hourly Usage"** heatmap section was added to **"Hourly Usage Report"** dashboard. When i copy the dashboard , the heatmap section points to a **"Hourly...

sethijaideep

Security Policy violation Binary Artifacts

129

_This issue was automatically created by [Allstar](https://github.com/ossf/allstar/)._ **Security Policy Violation** Project is out of compliance with Binary Artifacts policy: binaries present in source code **Rule Description** Binary Artifacts are an...

google-allstar-prod[bot]

fix typo

2

gemder -> gender

ryota-yamada-jp

Recently encountered an issue with a Customer where they needed to verify if on demand slots were being used for any projects. They wrote this query against INFORMATION_SCHEMA. Is this...

jdub55

Hi team, I found that several links in this [repo](https://github.com/GoogleCloudPlatform/bigquery-utils/tree/master/dashboards/system_tables) is not working like couple examples below:   (I remember the [public dashboard](https://datastudio.google.com/s/kGZzZJWkeyA) is working couple weeks ago but...

johanesalxd