We are in the final days to enter our Data and Analytics - "What's your why?" raffle with SparkED!

Reply with your "why" in text/video format to our forum post by January 28 to be entered! 

Alteryx Designer Discussions

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

NO COLUMNS Returned: PostgreSQL ODBC Connection

iamviraj13
8 - Asteroid

Hi,

I have a PostgreSQL 64-bit ODBC Connection installed and the connection is active. I am able to see the database in the Alteryx input tool too. 

But it shows as "No Columns Returned". Really need help with this. Would anyone be able to help me understand what might be going wrong?

I have attached a screenshot below for reference.

 

iamviraj13_0-1621874526072.png

 

2 REPLIES 2
mnorberg
Alteryx Community Team
Alteryx Community Team

Hi @iamviraj13,

 

This might be a permissions issue given that you can hit the table but not pull the field names. I'd recommend reaching out to your IT team or whoever runs the PostgresSQL database to make sure your credentials have the correct permissions set up. If they confirm your permissions are set up, it may be an issue with the visual query builder at which point it would be best to submit a case with our Support team by emailing support@alteryx.com.

priyasankadu
5 - Atom

Was this issue resolved? If so can you please post the reason? I am running in to the same issue. Thank you!!

Labels