topic Re: Get metadata of tables in hive metastore in Data Engineering

Get metadata of tables in hive metastore

DatabricksPract — Mon, 14 Aug 2023 10:13:46 GMT

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,

Tharun-Kumar — Mon, 14 Aug 2023 13:41:36 GMT

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.

DatabricksPract — Wed, 16 Aug 2023 02:08:22 GMT

@Tharun-Kumar - Thanks for your quick reply, it worked.