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:
The terraform seems to be correct
bigquery-utils/release/terraform/variables.tf
Lines 35 to 37 in b69879e
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 !