FROM SUBQUERY
INSERT using SUBQUERY according to the grammar.
Grammar Syntax
<insert statement> ::=
INSERT INTO <insertion target> <insert columns and source>
<insertion target> ::=
<table name>
<insert columns and source> ::=
<from subquery>
| <from constructor>
| <from default>
<from subquery> ::=
[ <left paren> <insert column list> <right paren> ]
[ <override clause> ]
<query expression>
Click here to go to the ANSI SQL Standard specification for this syntax.
This syntax is fully supported by Snowflake.
Sample Source Patterns
ANSI SQL Input Code
INSERT INTO TABLENAME ( COL1, COL2, COL3)
SELECT COL1, COL2, COL3
FROM OTHERNAME;
Snowflake Output Code
INSERT INTO TABLENAME ( COL1, COL2, COL3)
SELECT COL1, COL2, COL3
FROM OTHERNAME;
Related EWIs
Last updated
Was this helpful?