How To Use BigQuery Standard SQL UDF?

1.5k Views Asked by 蘇銘峰 At 15 April 2025 at 08:08

I refer to the BigQuery Standard SQL UDF Document

But I still do not know how to include js include BigQuery

I have tried to add js lib source in Options

But got this error Error: Not Implemented: UDFs are currently only supported for legacy SQL queries.

我參考了BigQuery Standard SQL UDF Document

但我還是不了解該如何將js include至BigQuery中

我有試著在Options新增js lib source

但是得到了這個錯誤 Error: Not Implemented: UDFs are currently only supported for legacy SQL queries.

There are 1 best solutions below

Elliott Brossard On 20 December 2016 at 01:09

Make sure not to include any text in the "UDF Editor" pane, which is specific to legacy SQL. Instead, the CREATE TEMPORARY FUNCTION statements should be in the Query Editor pane. See also the topic in the migration guide on differences in user-defined functions.