Bulk insert with db to db flows

3 votes

Having inserts into postgres and sqlserver work like redshift would be a nice improvement. Right now it runs a bunch of insert statements. Instead, pull source data to file, bulk import to temp table (copy command in postgres), then insert/merge sql command, all behind the scenes. Also allow us to specify the schema name in which to add the temp table, to avoid simultaneous wildcard syncs picking it up.

Done roadmap Suggested by: Bryan Upvoted: 15 Nov, '20 Comments: 1

Comments: 1