Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
community Alteryx IO Mission Control
alteryx Community
Search
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: 
Close
Free Trial

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Bulk Loader Capability for Postgres SQL

Status: Implemented Submitted by on ‎04-13-2018 08:46 AM
60 Comments (60 New)

Hi,

 

     Currently loading large files to Postgres SQL(over 100 MB) takes an extremely long time. For example writing a 1GB file to Postgres SQL takes 27 minutes! This is serious impacting our ability to use Alteryx as an ETL tool for loading our target Postgres Data Warehouse. We would really like to see the bulk load capacity to Postgres supported by Alteryx to help alleviate the performance issues.

 

Thanks,

Vijaya

58 Comments
JDong
8 - Asteroid
‎07-23-2020 01:54 AM

Thanks...I could also check with the Alteryx support and there is clear indication that shortly the bulk loader tool will be released

0 Likes
alexisjensen
8 - Asteroid
‎07-29-2020 05:45 PM

I am using it now in the pre-release GA version and it is working really well. Having to enter the connection details every time is a pain, but worth it for the bulk write capability.  I just loaded 1m rows to a cloud hosted postgres instance with a preceding auto field tool and it took 5:59m which is way faster than previously.

 

Alexis

0 Likes
KylieF
Alteryx Community Team
Alteryx Community Team
‎09-01-2020 09:49 AM
Status changed to: Implemented

Thank you for your feedback and support!

 

We're excited to say this feature has officially moved out of beta and is now available in the latest version of Alteryx, 2020.3, which is now available for download! Be sure to check it out and let us know what you think in the Designer Discussions board.

0 Likes
davidhenington
10 - Fireball
‎09-01-2020 11:33 AM

deleted

0 Likes
thedr9wningman
8 - Asteroid
‎09-01-2020 11:35 AM

Apparently, responding to email means I'm spoofing my friend, @davidhenington .

Thank you guys for making this happen!

 

-Cedric

0 Likes
bora_perusic
Alteryx Alumni (Retired)
‎09-03-2020 12:57 AM

Thanks for your patience, I hope you will enjoy this

 

Bora

0 Likes
davidhenington
10 - Fireball
‎09-03-2020 07:09 AM

 

 

Fantastic work @bora_perusic ! Proud to have participated! 

0 Likes
alexisjensen
8 - Asteroid
‎09-03-2020 01:44 PM
Really great work to you and the team!!!

Alexis

________________________________

DISCLAIMER
This email contains information that is confidential and which may be legally privileged. If you have received this email in error, you may not read, use, copy or disclose this email or its attachments in any way. In that event, please notify the sender immediately by reply email and delete the email from your system. While we use standard virus checking software, we accept no responsibility for viruses or anything similar in this email or any attachment after it leaves our information systems.
0 Likes
Labels