Explanation:
Box 1: Azure SQL Database
Use external Hive Metastore for Synapse Spark Pool
Azure Synapse Analytics allows Apache Spark pools in the same workspace to share a managed HMS (Hive Metastore) compatible metastore as their catalog.
Set up linked service to Hive Metastore
Follow below steps to set up a linked service to the external Hive Metastore in Synapse workspace.
* Open Synapse Studio, go to Manage > Linked services at left, click New to create a new linked service.
* Set up Hive Metastore linked service
* Choose Azure SQL Database or Azure Database for MySQL based on your database type, click Continue.
* Provide Name of the linked service. Record the name of the linked service, this info will be used to configure Spark shortly.
* You can either select Azure SQL Database/Azure Database for MySQL for the external Hive Metastore from Azure subscription list, or enter the info manually.
* Provide User name and Password to set up the connection.
* Test connection to verify the username and password.
* Click Create to create the linked service.
Box 2: A Hive Metastore
Reference: https://docs.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-external-metastore