Issues with Delta Sharing API when using Service Principal Token
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-19-2024 10:28 AM
Hello,
I am currently working with the Delta Sharing API and have encountered an issue when using a Service Principal token for authentication. The API call returns the following error:
[CANNOT_INFER_EMPTY_SCHEMA] Can not infer schema from empty dataset.
However, when I use a personal access token, the API works as expected.
My questions are:
1. Does the Delta Sharing API only support personal access tokens for authentication?
2. Is there any additional configuration or permission required when using a Service Principal token for Delta Sharing?
3. Has anyone else encountered this schema inference error, and how can it be resolved?
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-08-2024 11:40 AM
Please find the response below:
1) The Delta Sharing API supports both personal access tokens and service principal tokens for authentication.
2) Service principals need to be granted specific roles and permissions to access data. This includes assigning the service principal to appropriate groups and roles at both the account and workspace levels. Service principals must be explicitly granted access to data. This can be done at the account level using Unity Catalog or at the workspace level
3) The error [CANNOT_INFER_EMPTY_SCHEMA] Can not infer schema from empty dataset
suggests that the dataset being accessed is empty or the service principal does not have the necessary permissions to read the data. To resolve this:
- Ensure that the service principal has the correct permissions to access the dataset.
- Check if the service principal is correctly configured in the Unity catalog or the data governance framework.
https://docs.databricks.com/en/admin/users-groups/service-principals.html

