NO COLUMNS Returned: PostgreSQL ODBC Connection

Question

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.

mnorberg · Accepted Answer

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.