Redshift Import 2h for 13000 rows

Answered
Avatar
Permanently deleted user
Created

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

Votes

0

Share

3 comments
Avatar
vasily chernov
Created

@ 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
Avatar
Permanently deleted user
Created

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

0
Avatar
vasily chernov
Created

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

0

Please sign in to leave a comment.