Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

extracting data from PostgreSql DB

Sim
5 - Atom

I am trying to load the data from PostgresSql hosted in a container to Snowflake. 

The table sizes range from 6K to the largest table having around 500K records.

 

I am using the 9.02.01.00 PostgresSql driver. I tried the workflow for a small table of 6500 rows.

The connectivity is good. I can do a limit 10 or count(*) on the tables and the workflow runs fine.

 

But if I do a select * from <Table>, then input data tool fails with the below error

Error: Input Data (3): InboundNamedPipe::ReadFile:  Not enough bytes read. The pipe has been ended.

 

 

 

 

 

 

 

 

 

 

1 REPLY 1
joshuaburkhow
ACE Emeritus
ACE Emeritus

 Hi @Sim 

 

Based on the resolution here (I know it's a bit old but...) I would still reach out to support@alteryx.com and they can find out if there is something deeper going on

 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/The-Designer-x64-reported-InboundNamed...

 

Hope this helps!

Joshua Burkhow - Alteryx Ace | Global Alteryx Architect @PwC | Blogger @ AlterTricks
Labels