Amazon Redshift best practices for loading data

Loading very large datasets can take a long time and consume a lot of computing resources. How your data is loaded can also affect query performance. This section presents best practices for loading data efficiently using COPY commands, bulk inserts, and staging tables.

Topics

• Learn how to load data with a tutorial
• Use a COPY command to load data
• Use a single COPY command to load from multiple files
• Loading data files
• Compressing your data files
• Verify data files before and after a load
• Use a multi-row insert
• Use a bulk insert
• Load data in sort key order
• Load data in sequential blocks
• Use time-series tables
• Schedule around maintenance windows

Thanks for letting us know we're doing a good job!

If you've got a moment, please tell us what we did right so we can do more of it.

Thanks for letting us know this page needs work. We're sorry we let you down.

If you've got a moment, please tell us how we can make the documentation better.