Databricks Community

RichardSCarchit · 04-15-2023

I can see on Databricks SQL warehouse Data tab that clusters, catalogs and schemas have a unique ID. User created tables, views and functions must have and unique ID too, but it is not exposed to the user as far as I can tell.I need to retrieve the...

RichardSCarchit · 03-20-2023

I want to write a SQL query that queries the information_schema to generate a list of objects, their columns, relationships etc. - basically a data dictionary. For each object I want to show the DDL code, and I know I can get it by executing show c...

RichardSCarchit · 04-27-2023

Thanks you please inform if there is any progress. The information_schema views are very good and I use them regularly but it would be nice if they were expanded to be closer to oracle system views (object dependencies would be great, although we ca...

RichardSCarchit · 03-29-2023

Thanks but per my original post I cannot run Python in my cluster, only SQL. Above code throws an error.

Databricks Community

User Stats

User Activity

How to query object ID in Databricks SQL warehouse using only SQL?

How to extract DDL from tables/views using a SQL query?

Re: How to query object ID in Databricks SQL warehouse using only SQL?

Re: How to extract DDL from tables/views using a SQL query?