Hello Michael M,
As per the below documentation, Currently, Azure Synapse Analytics only supports Azure SQL Database and Azure Database for MySQL as an external Hive Metastore.
If you don’t have a database, you need to consider setting up "Azure SQL database" or "Azure Database for MySQL" to connect Azure Synapse Analytics with a Hive Metastore.
Reference document:
https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-external-metastore#set-up-linked-service-to-hive-metastore
Known limitations
- Synapse Studio object explorer will continue to show objects in managed Synapse metastore instead of the external HMS.
- SQL <-> Spark synchronization doesn't work when using external HMS.
- Only Azure SQL Database and Azure Database for MySQL are supported as external Hive Metastore database. Only SQL authorization is supported.
- Currently Spark only works on external Hive tables and non-transactional/non-ACID managed Hive tables. It doesn't support Hive ACID/transactional tables.
- Apache Ranger integration is not supported.
I hope this answers your quesiton.
If this answers your question, please consider accepting the answer by hitting the Accept answer and up-vote as it helps the community look for answers to similar questions.