We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.

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

 

1 REPLY 1
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.

Labels