cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Administration & Architecture
Explore discussions on Databricks administration, deployment strategies, and architectural best practices. Connect with administrators and architects to optimize your Databricks environment for performance, scalability, and security.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

How do I access Hive Metastore via API?

Ninad-Mulik
New Contributor III

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.

1 ACCEPTED SOLUTION

Accepted Solutions

SP_6721
Honored Contributor

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

2 REPLIES 2

SP_6721
Honored Contributor

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.

Ninad-Mulik
New Contributor III

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