SSC-EWI-BQ0005
Javascript code has not been validated.
Severity
High
Description
SnowConvert does not transform Javascript code. Since the Javascript code extracted from BigQuery's functions hasn't been changed at all, this code might need some tweaks to work on Snowflake.
Code Example
Input Code:
CREATE FUNCTION test.languageJs (x integer, y integer)
RETURNS integer
LANGUAGE js
AS "return x * y;";Output Code:
CREATE FUNCTION test.languageJs (x integer, y integer)
RETURNS DOUBLE
LANGUAGE JAVASCRIPT
COMMENT = '{ "origin": "sf_sc", "name": "snowconvert", "version": { "major": 0, "minor": 0, "patch": "0" }, "attributes": { "component": "bigquery", "convertedOn": "07/16/2025", "domain": "no-domain-provided" }}'
!!!RESOLVE EWI!!! /*** SSC-EWI-BQ0005 - JAVASCRIPT CODE HAS NOT BEEN VALIDATED. ***/!!!
AS
$$
return x * y;
$$;Recommendations
Review all Javascript code before deployment.
Javascript parameters in Snowflake must be uppercase.
For more information, visit Snowflake's Introduction to Javascript UDFs.
If you need more support, you can email us at [email protected]
Last updated