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:

BigQuery

IN -> BigQuery_01.sql

CREATE FUNCTION test.languageJs (x integer, y integer)
RETURNS integer
LANGUAGE js
AS "return x * y;";

Output Code:

Snowflake

OUT -> BigQuery_01.sql

CREATE FUNCTION test.languageJs (x DOUBLE, y DOUBLE)
RETURNS DOUBLE
LANGUAGE JAVASCRIPT
!!!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 [e-mail]