Bulk Loader Capability for Postgres SQL

[Nelavv]

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

[bora_perusic]

@alexisjensen we cannot commit to timelines but I hope we can start the development on this (PG bulkloader) early 2020, it is literally a next item on the roadmap. Please, stay tuned, we should have some good news relatively soon.

[NicolasFabre81]

Good news !

Waiting for it, the Python workaround given by @Yuges81 works very well.

[davidhenington]

@bora_perusic Great to hear Bora thank you! 

[MILKEYSUFC]

Excellent news!

Python workaround is good but will be so much better for our maintenance having this bulk load capability.

[nickmiranda]

+1

[ChristianLaws]

+1

[bora_perusic]

All; the PostgreSQL Bulk Loader beta has been prepared, if you are interested in helping us with the beta evaluation, please, follow the standard Beta program to get your version.

Thanks for your patience

Bora

[davidhenington]

@bora_perusic Big step Bora! Thanks so much for your hard work!