javascript - 将 javascript 库包含到 Snowflake UDF 中

Question

我有兴趣让 JS UDF 工作，而无需在函数开头粘贴一堆代码。

有人知道是否有任何类似的方法可以像 BigQuery 那样在 UDF 中包含 javascript 库吗？

https://cloud.google.com/bigquery/docs/reference/standard-sql/user-defined-functions#including-javascript-libraries

我很想知道它是否至少在 Snowflake 的路线图中，或者是否有另一种方法来处理这种情况。

Answer 1

Restrictions on Stored Procedures :

Stored procedures have the following restrictions:

• The JavaScript code cannot call the JavaScript eval() function.

• JavaScript stored procedures support access to the standard JavaScript library. Note that this excludes many objects and methods typically provided by browsers. There is no mechanism to import, include, or call additional libraries. Allowing 3rd-party libraries could create security holes.