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.