This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

How it do insertion faster for redshift

amardeep2021
New Contributor III

‎02-02-2022 09:08 AM

I am trying insert 70K records in loop till a condition is false. Looping logic working fine. But, I see it takes 1 hour to insert 70K records each time. PFA of the pipeline I am executing. Is there a way to perform insertion faster? Any tips would be helpful.

Regards,
Amar.

Screen Shot 2022-02-02 at 9.05.48 AM

0 Kudos
Reply
10 REPLIES 10

amardeep2021
New Contributor III

‎02-04-2022 07:54 AM

I stopped the execution as it was running for 49 hours.

0 Kudos
Reply