Getting "storage_root does not specify a URI scheme." while setting ADLS path in default metastore.

Akancha 0 Reputation points
2024-11-18T11:01:44.11+00:00

Hi Team,

I am facing while setting the ADLS path for the existing default metastore in account console page in azure.

Below is the image showing i have already created the container and have enabled Hierarchical namespace as well.

User's image

But getting below error while setting the path at metastore
User's image

Kindly suggest.

Regards,

Akancha

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,513 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Keshavulu Dasari 2,570 Reputation points Microsoft Vendor
    2024-11-18T17:17:49.2133333+00:00

    Hi Akancha,
    Welcome to Microsoft Q&A Forum. Thanks for posting you query here!
    The error "storage_root does not specify a URI scheme" is due to the format of the storage path you're providing. The path should include the URI scheme, which typically starts with abfss:// for Azure Data Lake Storage Gen2.

    Try updating the path in the input field to include the URI scheme. For example, if your container name is mycontainer and your ADLS account name is adbsaccount01, the path should look something like this:

    
    abfss://mycontainer@adbsaccount01.dfs.core.windows.net/
    
    

    Make sure to replace mycontainer with your actual container name. This should resolve the error you're encountering. If you continue to face issues, double-check that you have the necessary permissions and direct access to the specified path.
    Permissions: Verify that the storage account and container have the necessary permissions set up. The account you're using should have the appropriate access rights to the storage container.

    Configuration: Double-check the configuration settings in the Azure portal. Sometimes, re-entering the details or refreshing the settings can help resolve such issues.

    Documentation: Refer to the Azure Databricks documentation for setting up a Unity Catalog metastore. It provides detailed steps and examples that might help you identify any missing configurations


    Please do not forget to "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members. 
    If you have any other questions or are still running into more issues, let me know in the "comments" and I would be happy to help you


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.