Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Running an SQL query via alteryx

Amourous12
6 - Meteoroid

Hi,

 

I am needing to check the size of multiple databases/tables in SQL, I am using (sp_spaceused [tablename]) however as I have over 100 tables, looking to see if i can run this query via alteryx. Basically looking to see if Alteryx can run queries on a db to get information about the tables not the data itself to then store somewhere else

 

Thanks.

1 REPLY 1
apathetichell
19 - Altair

Many DBs have a metadata table which would contain information on other tables. Start by identifying that table.

Labels