GoogleCloudPlatform/bigquery-utils

Missing UDF in region europe-west3

Closed this issue · 2 comments

When trying to run the following SQL code in a BigQuery project located in europe-west3

bqutil.fn_europe_west3.typeof(arr)

I get the following error:

Access Denied: Routine bqutil:fn_europe_west3.typeof: User does not have permission to invoke routine bqutil.fn_europe_west3.typeof. 

I guess the dataset exists otherwise the error would have been different, but is missing some permission compared to other regions:

image

The terraform seems to be correct

"europe-north1",
"europe-west3",
"europe-west2",

But something might have gone wrong when making the dataset public ? Or did I overlooked something on my side regarding to permission when it comes to using those UDFs ?

Thanks !

Hello, nice catch! That was a permission that was missed on our end. It has been updated and you should be able to run it now

It works. Thank you for the quick fix !