Table Counts

sumner-williams — Fri, 15 Aug 2025 21:31:03 GMT

Hello,

My company loads a lot of tables into a databricks schema. I would like to build a dashboard on what has been loaded, but SQL commands like select * from information_schema do not work. Instead we have SHOW TABLES {FROM} LIKE {}; And that fails to work in a dashboard, but does work in Queries.

From a Notebook, I can get a list of all tables. When I do display(tables) that can go into a notebook, but I lose all of the widgets. So I can't do anything like count() or create a pivot table, etc.

Are there ideas on how I can start making a dashboard of what is loaded into a schema?

Thank you

Re: Table Counts

BS_THE_ANALYST — Sat, 16 Aug 2025 11:57:56 GMT

Just trying to rule out some of the lower-hanging stuff. When you run your SQL statements i.e.

select * from information_schema

Are you using the correct namespace syntax i.e. {catalog_here}.information_schema
Are you using Unity Catalog?

Example of the first point:
I'd try both SQL Editor & Notebooks to rule anything out.

Command:

SELECT * FROM CATALOGHERE.information_schema.tables;

I wonder if you have sufficient privileges when you're trying to write the query. Please let us know the error message

All the best,
BS

topic Re: Table Counts in Get Started Discussions

Table Counts

Re: Table Counts