DECLARE
Translation reference to convert Teradata DECLARE statement to Snowflake Scripting
Description
Declares one or more local variables.
For more information regarding Teradata DECLARE, check here.
DECLARE variable_name [, variable_name ]... DATA_TYPE [ DEFAULT default_value]
Sample Source Patterns
Teradata
CREATE PROCEDURE declareExample ( )
BEGIN
DECLARE COL_NAME, COL_TYPE VARCHAR(200) DEFAULT '' ;
DECLARE COL_COUNT, COL_LEN INTEGER;
END;
Snowflake Scripting
CREATE OR REPLACE PROCEDURE PUBLIC.declareExample ( )
RETURNS VARCHAR
LANGUAGE SQL
EXECUTE AS CALLER
AS
$$
BEGIN
LET COL_NAME VARCHAR(200) DEFAULT '';
LET COL_TYPE VARCHAR(200) DEFAULT '';
LET COL_COUNT INTEGER;
LET COL_LEN INTEGER;
END;
$$;
Known Issues
No issues were found.
Related EWIs
No related EWIs.
Last updated
Was this helpful?