Hi every one, I'm trying to create a database in Synapse Spark Notebook, but I'm getting this error: The very same error appears without the keyword LOCATION Regards Jona

@Jona Greetings & Welcome to Microsoft Q&A forum! Thanks for posting your query! Creating a database in Azure Synapse Spark can fail due to various issues, such as workspace configuration problems or metastore access errors. If you encounter this error, consider checking your workspace settings, ensuring you have the necessary permissions, or trying to create a new workspace if the issue persists. Here are a few common causes and troubleshooting steps: Check Workspace Configuration - Ensure that your Azure Synapse workspace is properly set up. Verify that all necessary services are enabled and that it is linked to the correct Azure Data Lake Storage. Verify Permissions - Make sure you have the appropriate permissions to create databases. You may need roles such as Synapse Administrator or Blob Storage Contributor. You can check your permissions in the Azure portal under the IAM settings. Inspect Metastore Access - The error might be related to accessing the metastore. Ensure that it is correctly configured and that the storage account used for the metastore is accessible. Network Configuration - If your workspace is set up with a private network, check that all required endpoints are configured correctly. Missing private endpoints can lead to access issues. Check for Case Sensitivity - Be cautious about case sensitivity in paths. If there are directories with similar names, it could cause confusion. For additional information, please refer: How-to: Create an empty lake database I hope this information helps. Please do let us know if you have any further queries. Kindly consider upvoting the comment if the information provided is helpful. This can assist other community members in resolving similar issues. Thank you.

Error on creating Synapse Spark database

Jona 555

Hi every one,

I'm trying to create a database in Synapse Spark Notebook, but I'm getting this error:

User's image

The very same error appears without the keyword LOCATION

Regards

Jona

Chandra Boorla 7,735 Reputation points Microsoft Vendor

2025-01-29T19:25:37.4866667+00:00

@Jona

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

1 answer

Chandra Boorla 7,735 Reputation points Microsoft Vendor

2025-01-29T00:28:28.64+00:00

@Jona

Greetings & Welcome to Microsoft Q&A forum! Thanks for posting your query!

Creating a database in Azure Synapse Spark can fail due to various issues, such as workspace configuration problems or metastore access errors. If you encounter this error, consider checking your workspace settings, ensuring you have the necessary permissions, or trying to create a new workspace if the issue persists.

Here are a few common causes and troubleshooting steps:

Check Workspace Configuration - Ensure that your Azure Synapse workspace is properly set up. Verify that all necessary services are enabled and that it is linked to the correct Azure Data Lake Storage.

Verify Permissions - Make sure you have the appropriate permissions to create databases. You may need roles such as Synapse Administrator or Blob Storage Contributor. You can check your permissions in the Azure portal under the IAM settings.

Inspect Metastore Access - The error might be related to accessing the metastore. Ensure that it is correctly configured and that the storage account used for the metastore is accessible.

Network Configuration - If your workspace is set up with a private network, check that all required endpoints are configured correctly. Missing private endpoints can lead to access issues.

Check for Case Sensitivity - Be cautious about case sensitivity in paths. If there are directories with similar names, it could cause confusion.

For additional information, please refer: How-to: Create an empty lake database

I hope this information helps. Please do let us know if you have any further queries.

Kindly consider upvoting the comment if the information provided is helpful. This can assist other community members in resolving similar issues.

Thank you.
Please sign in to rate this answer.
Chandra Boorla 7,735 Reputation points Microsoft Vendor

2025-01-30T19:07:07.8733333+00:00

@Jona

Following up to see if the above answer was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Jona 555 Reputation points

2025-02-01T23:53:52.9933333+00:00

Hi

How could I check the metastore?

Regards

Chandra Boorla 7,735 Reputation points Microsoft Vendor

2025-02-05T02:34:32.5266667+00:00

@Jona

Apologies for the delay in response.

To check the metastore configuration in Azure Synapse, please consider the following steps that might help you:

Access Synapse Studio - Go to the Azure portal and open your Synapse workspace - Click on "Open Synapse Studio" to access the Synapse Studio interface.

Check Linked Services - In Synapse Studio, navigate to the "Manage" hub. Under "Linked services", ensure that a linked service is configured for your Azure Data Lake Storage Gen2 account, which serves as the metastore.

Verify Storage Account Access - Confirm that the storage account used for the metastore is accessible from your Synapse workspace. Ensure you have the necessary permissions (e.g., Storage Blob Data Contributor) to read and write to the storage account.

Review Metastore Settings -

If using an external Hive metastore - Check the connection details (server name, database name, authentication) configured in Linked Services.

If relying on the default metastore, ensure it is enabled and properly configured.

Test Connectivity - Use tools like Azure Storage Explorer or SQL Server Management Studio to manually access the data lake storage or the metastore database. Run the following command in your Synapse Spark notebook to confirm metastore accessibility:

%%sql SHOW DATABASES;

Check Synapse - Logs Review logs and error messages in Synapse Studio for more details about the issue.

Validate Network Configuration - If your Synapse workspace is set up in a private network, verify that all required private endpoints (e.g., for storage or metastore access) are configured and reachable.

For more details, please refer: Use external Hive Metastore for Synapse Spark Pool

I hope this information helps.

Chandra Boorla 7,735 Reputation points Microsoft Vendor

2025-02-06T00:50:23.55+00:00

@Jona

Following up to see if the above suggestion was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Error on creating Synapse Spark database

1 answer

Your answer