Can we list all tables and views having a specific column names by writing SQL queries or any other way like UI in Dremio. I am wondering about some thing like in database where we can scan metadata tables.
I tried to execute below query
SELECT * FROM INFORMATION_SCHEMA.COLUMNS
However getting below error-