Running an SQL query via alteryx

Question

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.

apathetichell · Answer

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