04 Oct 19 ·  nVector in Snowflake ·        Bookmark ·  Report ·  More actions.. Lock comments ·  Pin thread

Insert into table command syntax in Snowflake

Insert one or more rows into the table from another table

INSERT into Inventory_New 
SELECT * FROM Inventory;

To insert individual values:

INSERT into Inventory (product, quantity)
VALUES('top load washer', 10),
('front load washer', 20),
('dryer', 30),
('refrigerator', 10);


posted on 04 Oct 19

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds