Here is how to insert data into redshift table. You can use it to insert multiple rows, insert into sortkey and insert into identity column.
insert data
How To Insert Data in SQL Server
Here is how to insert data in SQL Server. You can insert multiple rows or insert json in SQL Server.