How do I access Hive Metastore via API?

Ninad-Mulik
Databricks Partner

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.

SP_6721
Honored Contributor II

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.

View solution in original post

Ninad-Mulik
Databricks Partner

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