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
