SET

Translation reference to convert Teradata SET statement to Snowflake Scripting

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

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

CREATE OR REPLACE PROCEDURE PUBLIC.setExample ( PARAM1 FLOAT )
RETURNS FLOAT
LANGUAGE SQL
EXECUTE AS CALLER
AS
$$
   BEGIN
      LET COL_COUNT INTEGER;
      COL_COUNT := 3;
      PARAM1 := COL_COUNT + 1;
      RETURN PARAM1;
   END;
$$;

Result

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

Known Issues

No issues were found.

Related EWIs

No related EWIs.