community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
Announcement | We'll be doing maintenance between 9am-11am MT on Saturday, January 25th, which may impact your experience. Thanks for your patience as we work on improving the community!

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

39 Comments
Alteryx Partner

nice trend here 🙂

This appears to be a purchase killer for Liaison who manages and hosts data warehouses and analytical tools for our clients.  Please indicate ASAP when this issue will be resolved, as we have a current customer for which we likely take a different technological direction and have not purchased licenses.

 

Thanks,

Jeff Feinsmith

OpenText / Liaison Technologies

 

Meteor

We really need this feature. As this is the whole idea of choosing Alteryx over other ETL tools....

Atom

+1

I've seen threads on this dated to 2015 with no movement.... I'd suggest anyone else waiting switch to FME for your ETL. They have supported the postgres copy command for years....

Atom

+1

+1

 

This would be a huge win for our data processing requirements

Meteor

+1

 

My current workflow takes circa 4 hours using the output tool directly into Postgres, or 15 minutes if I export to CSV and they execute a batch of copy commands. This needs to be addressed ASAP.

Alteryx Partner
+1

this issue is one and the same with GP in-db, which uses postgresql as a language. Bulk load is a must have. If you fix it for postgresql it could be used in GP. 

 

Not sure why this is in planning but Greenplum got cancelled...