SSC-EWI-BQ0005

Javascript code has not been validated.

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

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 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]