How to Insert Data in Snowflake
Last updated July 24, 2026 · By the SaturnSQL team
Use INSERT INTO ... VALUES for a few rows, or INSERT INTO ... SELECT to insert query results. For bulk file loads, COPY INTO from a stage is far faster than many INSERTs.
Insert literal rows
INSERT INTO orders (id, customer_id, amount)
VALUES
(1, 101, 42.50),
(2, 102, 17.00);Insert from a query
INSERT INTO big_orders
SELECT * FROM orders WHERE amount > 1000;Bulk loads
Loading files? Use COPY INTO from an internal or external stage instead of INSERT; it parallelizes and is dramatically cheaper for large volumes.
COPY INTO orders FROM @my_stage/orders/ FILE_FORMAT = (TYPE = 'CSV' SKIP_HEADER = 1);Run this in SaturnSQL
SaturnSQL is a browser-based SQL editor for teams: shared query library, schema-aware autocomplete, and scheduled exports to Google Sheets and Slack.
Try it free