SSC-EWI-RS0002
Set "configuration parameter" is not supported in Snowflake.
Severity
Medium
Description
The use of SET configuration parameter
is not supported by Snowflake. For more information please refer to CREATE PROCEDURE documentation.
Code Examples
Input Code:
CREATE OR REPLACE PROCEDURE procedure2(
IN input_param INTEGER,
OUT output_param NUMERIC
)
AS $$
BEGIN
output_param := input_param * 1.7;
END;
$$
LANGUAGE plpgsql
SET enable_numeric_rounding to ON;
Output Code:
CREATE OR REPLACE PROCEDURE procedure2 (input_param INTEGER, output_param NUMERIC)
RETURNS VARIANT
LANGUAGE SQL
!!!RESOLVE EWI!!! /*** SSC-EWI-RS0002 - SET CONFIGURATION PARAMETER 'enable_numeric_rounding' IS NOT SUPPORTED IN SNOWFLAKE. ***/!!!
SET enable_numeric_rounding to ON
COMMENT = '{ "origin": "sf_sc", "name": "snowconvert", "version": { "major": 0, "minor": 0, "patch": "0" }, "attributes": { "component": "redshift", "convertedOn": "03/03/2025", "domain": "test" }}'
AS $$
BEGIN
output_param := input_param * 1.7;
RETURN OBJECT_CONSTRUCT('output_param', :output_param);
END;
$$;
Recommendations
If you need more support, you can email us at [email protected]
Last updated