search

datamill-co / target-redshift

A Singer.io Target for Redshift
MIT License
23 stars 17 forks source link

Disable COMPUPDATE and STATUPDATE during copy for performance? #47

Open FostersData opened 3 years ago

FostersData commented 3 years ago

Per this article, performance may be improved by adding COMPUPDATE OFF STATUPDATE OFF to COPY queries.

Note that PipelineWise takes this approach in their target-redshift implementation