Normal
0
false
false
false
EN-US
X-NONE
X-NONE
Data analysts want data in their data warehouse. When transaction-optimized databases were used for warehousing analysts would replicate data from manufacture systems into the data warehouse at the cost of change throughput. Analytics data warehouses are usually loaded numerous times each day, but often clients want to revive data every hour, every minute. This post outlines best practices for using Amazon Redshift for micro-batch loading and is planned for data architects, data modelers, and DBAs. Any data model can be laden via micro-batching, but data prepared as a time series is often ideal for this type of loading. To make the COPY command as capable as probable, ask it to do as little as promising . Read more at:
http://blogs.aws.amazon.com/bigdata/post/Tx2ANLN1PGELDJU/Best-Practices-for-Micro-Batch-Loading-on-Amazon-Redshift