search

GoogleCloudPlatform / bigquery-utils

Useful scripts, udfs, views, and other utilities for migration and data warehouse operations in BigQuery.
https://cloud.google.com/bigquery/
Apache License 2.0
1.11k stars 277 forks source link

Discussion: Create bqutil UDFs in all other non-US datasets #381

Closed 1987yama3 closed 4 months ago

1987yama3 commented 1 year ago

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 fact that these useful UDFs are only available in the US region is frustrating. There are many opportunities to work for clients living in Japan, and there are many cases where it is set in the Japan region.

Any ideas for deploying UDFs to other regions? For example, bqutil.fn_ane1.get_value() and bqutil.fn_tyo.get_value() are suggested. ane1 means asia-northeast-1, and TYO is the city code for Tokyo.

Thanks,

afleisc commented 4 months ago

Hello, UDFs are now available in all BQ supported regions! Please see https://github.com/GoogleCloudPlatform/bigquery-utils/pull/405 and docs to use regional UDFs