Redshift Import 2h for 13000 rows

Answered

I used Data import feature and it took 1h 53m to import 13 000 rows with only one column. Any idea why?

3 comments
Comment actions Permalink

@ Dawid Nawrot ,

RedShift JDBC driver doesn't support batch inserts. Now IDE implements 13K inserts one by one.

Follow Amazon Redshift Best Practices for Loading Data https://docs.aws.amazon.com/redshift/latest/dg/c_loading-data-best-practices.html

1
Comment actions Permalink

Makes sense. Thanks for prompt reply. I will use COPY command from S3 from now on

0
Comment actions Permalink

We will implement batch inserts when Amazon implements this feature in JDBC driver.

0

Please sign in to leave a comment.