Input List of Tables from ODBC Database

Hello Community! When you connect to an ODBC database with the Input Data tool, you can see all the tables in that database. Is there a way to input this table list as data into Alteryx (1 row per table)? I know Alteryx cache's the list when you are choosing a table (or specifying a query). Does anyone know where the list is cached? Thank you!

Database Connection

Accepted answers

Aguisande

Hi @DultonM

Have you tried querying the sys.tables table? That'll give you the whole list, directly from the DB...

tables.table.PNG

patrick_digan

@DultonM The cache is stored here in text files:

C:\Users\<<YOUR ID>>\AppData\Roaming\Alteryx\VQBCache

I don't quite know where it stores the data name since the files in that folder are all long GUID.

All comments

Aguisande

Hi @DultonM

Have you tried querying the sys.tables table? That'll give you the whole list, directly from the DB...

tables.table.PNG

DultonM

Hi @Aguisande,

Your solution worked for one of the ODBC databases I am interested in connecting to! Unfortunately, I do not have access to the sys.tables table in another ODBC. It's possible that I'm being restricted from seeing that by my IT team. That is why i am particularly interested in where Alteryx caches the table list.

jdhanapa

Can you share the query you used?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703