List of Tables in Visual Query Builder

[prateekvarshney]

I'm using Alteryx Designer 2021.3.1.47945, and I'm not able to see the list of tables present in the Redshift database through "Visual Query Builder". But the list of tables is can be seen in the tables tab.

Is there some setting or configuration that has to be enabled to view the list of tables in the database through Visual Query Builder?

[AngelosPachis]

Hi @prateekvarshney ,

Maybe this post describes the situation you're facing?

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Table-list-of-database-not-loading-in-...

Do you have only views in your database?

Kind regards,

Angelos

[prateekvarshney]

There are no views created in the database, only tables.

[AngelosPachis]

Not sure why then @prateekvarshney . Are you sure the tables are still there then? It seems that the table list was last updated on the 10th of Dec (although it's unlike someone to have dropped all tables from then and nobody has noticed). What if you refresh?

[prateekvarshney]

The tables are still present in the database. I even hit the refresh button, but the issue still persists.

[prateekvarshney]

I even tried adding the objects in the Visual Query Builder. But there also the drop-down seems to be empty.