aws redshift: insert multiple rows into a table

Way to insert multiple rows into a redshift table using sql insert command:

insert into category_stage values
(default, default, default, default),
(20, default, 'Country', default),
(21, 'Concerts', 'Rock', default);

See:

https://docs.aws.amazon.com/redshift/latest/dg/c_best-practices-multi-row-inserts.html

Leave a comment