04 Oct 19 · npack ·       Add to Favorites  

Insert into table command syntax in Snowflake

Insert one or more rows into the table from another table

INSERT into Inventory_New 
(
product,
quantity,
supply_constrained
)
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);

npack

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

Copied