Question
What is the fastest way to load data into Redshift from S3?
Click to reveal answer
Answer
The COPY command, which loads in parallel across compute nodes.
Click to flip back
All Redshift Flashcards
Q: What is the fastest way to load data into Redshift from S3?
A: The COPY command, which loads in parallel across compute nodes.
Q: What does Redshift Spectrum do?
A: Queries data directly in S3 without loading it into Redshift tables.
Q: Name the four Redshift distribution styles.
A: AUTO, KEY, EVEN, and ALL.
Q: What are sort keys used for?
A: Sort keys enable zone maps for efficient range-based filtering, reducing scanned blocks.
Q: What is Redshift WLM?
A: Workload Management — assigns queries to queues with memory and concurrency limits for prioritization.
Q: What does the UNLOAD command do?
A: Exports Redshift query results to S3 in parallel.