SET

Translation reference to convert Teradata SET statement to Snowflake Scripting

Some parts in the output code are omitted for clarity reasons.

Description

Assigns a value to a local variable or parameter in a stored procedure.

For more information regarding Teradata SET, check here.

SET assigment_target = assigment_source ;

Sample Source Patterns

Teradata

Query

IN -> Teradata_01.sql

CREATE PROCEDURE setExample ( OUT PARAM1 INTEGER )
BEGIN
    DECLARE COL_COUNT INTEGER;
    SET COL_COUNT = 3;
    SET PARAM1 = COL_COUNT + 1;
END;

Result

|PARAM1 |
|-------|
|4      |

Snowflake Scripting

Query

OUT -> Teradata_01.sql

CREATE OR REPLACE PROCEDURE setExample (
--                                         OUT
                                             PARAM1 FLOAT)
RETURNS VARIANT
LANGUAGE SQL
COMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},{"attributes":{"component":"teradata"}}'
EXECUTE AS CALLER
AS
$$
    BEGIN
        LET COL_COUNT INTEGER;
        COL_COUNT := 3;
        PARAM1 := COL_COUNT + 1;
        RETURN PARAM1;
    END;
$$;

Result

|PARAM1 |
|-------|
|4      |