Categories:

Query Syntax

INTO

Sets Snowflake Scripting variables to the values in a row returned by a SELECT statement. See Setting Variables to the Results of a SELECT Statement for details.

Syntax

SELECT <expression1>
   [ , <expression2> ]
   [ , <expressionN> ]
[ INTO :<variable1> ]
   [ , :<variable2> ]
   [ , :<variableN> ]
FROM ...
WHERE ...
[ ... ]

Where:

expression1, . expression2, . expressionN

Specifies scalar expressions (e.g. columns in a table specified by the FROM clause).

variable1, . variable2, . variableN

Snowflake Scripting variables that should be set to the values in the expressions in the SELECT clause.

Usage Notes

  • The SELECT statement must return a single row.

Language: English