Postgres Bulk Loader - 2019.1

JDong

Hi All

I have a flow and performing multiple bulk loads into postgres tables using the new 'Bulk' connection which was released with 2020.3

The flow works perfectly fine on designer. Now I want to save this file on Alteryx Gallery v2019.1 using 2019.1 non admin designer and it throws the below error messages.

-----------------------------------------------------------------------------

Please advise on how to save this flow on the server 2019.1 and get it to work.

Thanks

gtorres8

Hi @JDong,

That's great to hear that the PostgreSQL Bulk works for you on Designer 2020.3. The issue most likely is that Alteryx Server 2019.1 does not recognize the "pgbi" format in the connection string because it didn't exist prior to 2020.3. It's best practice to keep all Designer clients to match Alteryx Server if publishing workflows to Gallery to avoid compatibility issues.

As mentioned, the PostgreSQL Bulk feature is new to 2020.3 and higher and it will not work on any Designer or Server version prior.