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);

nVector

posted on 04 Oct 19