Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!
The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

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

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

60 Comments
spmiller15
5 - Atom

Agreed 100%, this is a showstopper...

mgoldwassertrp
6 - Meteoroid

+1 

 

For context, see the Postgres COPY command: https://www.postgresql.org/docs/current/static/sql-copy.html

 

If there is any way to add this functionality in, it would vastly improve performance for Postgres Databases. By default, records are inserted one at a time.

 

The Postgres bulk insert should be pretty similar to the Redshift bulk insert functionality (already available in Alteryx), because Redshift was essentially forked from Postgres.

Atabarezz
13 - Pulsar

+1

csundaram
5 - Atom

As a solution architect when people ask me what's the diff between using a formal ETL tool and Alteryx this feature pops to the top of the list. Enabling bulk load would really help alleviate the issue.

Atabarezz
13 - Pulsar

exactly!

Atabarezz
13 - Pulsar

any updates?

ARich
Alteryx Alumni (Retired)
Status changed to: Under Review
 
_olivierbisthoven
7 - Meteor

+1 

acowpy
8 - Asteroid

+1

jfeinsmith
5 - Atom

+1