topic Re: How do I access Hive Metastore via API? in Administration & Architecture

How do I access Hive Metastore via API?

Ninad-Mulik — Mon, 21 Jul 2025 07:19:55 GMT

Hi,
Is there any Databricks REST API to directly access Hive Metastore tables (like list of tables, schemas, columns) without using Unity Catalog or SQL Warehouse?

I’m specifically looking to fetch metadata from hive_metastore.

Thanks.

Re: How do I access Hive Metastore via API?

SP_6721 — Mon, 21 Jul 2025 11:30:14 GMT

Hi @Ninad-Mulik ,

As far as I know, there’s no Databricks REST API to directly access Hive Metastore metadata without using Unity Catalog or SQL Warehouses. The legacy Hive Metastore only supports SQL-based queries. REST APIs for metadata access are only available through Unity Catalog.

Re: How do I access Hive Metastore via API?

Ninad-Mulik — Wed, 23 Jul 2025 05:40:36 GMT

So evenly i can query sql statement through api endpoint all i need is to spin up a cluster before to it, aint it?