- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-14-2023 03:11 AM - edited 08-14-2023 03:13 AM
Hi team,
I have a requirement to get the metadata of tables available in databricks hive metastore.
Is there any way to get the metadata of all the tables inspite of looping through tables using Describe table_name.
As hive metastore doesnot support information schema, please suggest if we have any other approaches.
Thanks in advance,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-14-2023 06:41 AM
You can use
%sql
show table extended in <database_name> like '*'This would give the information of the all the tables in the database provided.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-15-2023 07:08 PM
@Tharun-Kumar - Thanks for your quick reply, it worked.
