Forum Discussion
Mirrored Azure Databricks Catalog
Hi Srisakthi
I haven't used this preview feature yet. I went through the relevant documentations, it seems you’ve already covered many of the necessary steps for setting up and querying unmanaged (external) tables in Azure Databricks Unity Catalog. Here are a few additional things you might want to check:
-
Storage Credential and External Location: Ensure that the storage credential and external location are correctly configured and associated with the external table. The external location should be accessible with the storage credential you have set up.
-
Permissions on External Location: Verify that the necessary permissions are granted on the external location. This includes ensuring that the user or service principal has theREAD and WRITE permissions on the Azure Data Lake Storage (ADLS) path.
- Schema Permissions: Double-check that the EXTERNAL_USE_SCHEMA, SELECT, and USE permissions are correctly applied to the schema containing the external table.
-
Network Configuration: Since your ADLS is not under any private network, ensure that there are no network restrictions or firewall rules that might be blocking access to the external storage.
-
Error Messages: Review the error messages when you failed to query from the external tables. It might give more insight into what is going wrong. Did you see any specific error messages?
If you’ve verified all these aspects and are still facing issues, it might be helpful to reach out to Fabric support for more detailed troubleshooting.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!-
Hi Srisakthi
I haven't used this preview feature yet. I went through the relevant documentations, it seems you’ve already covered many of the necessary steps for setting up and querying unmanaged (external) tables in Azure Databricks Unity Catalog. Here are a few additional things you might want to check:
-
Storage Credential and External Location: Ensure that the storage credential and external location are correctly configured and associated with the external table. The external location should be accessible with the storage credential you have set up.
-
Permissions on External Location: Verify that the necessary permissions are granted on the external location. This includes ensuring that the user or service principal has theREAD and WRITE permissions on the Azure Data Lake Storage (ADLS) path.
- Schema Permissions: Double-check that the EXTERNAL_USE_SCHEMA, SELECT, and USE permissions are correctly applied to the schema containing the external table.
-
Network Configuration: Since your ADLS is not under any private network, ensure that there are no network restrictions or firewall rules that might be blocking access to the external storage.
-
Error Messages: Review the error messages when you failed to query from the external tables. It might give more insight into what is going wrong. Did you see any specific error messages?
If you’ve verified all these aspects and are still facing issues, it might be helpful to reach out to Fabric support for more detailed troubleshooting.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
Hi Jing, Yeah as I mentioned earlier all those options are enabled already. Here is the screenshot of the error.
Thanks,
Srisakthi
Hi Srisakthi
Have you tried using other tools to connect to its SQL analytics endpoint and query data from the unmanaged tables? Would it succeed?
Best Regards,
Jing
