Troubleshoot common sharing issues in Delta Sharing
The following sections describe common errors that might occur when you create a share or access data in a share.
Accessing data within a share
The following errors are common when accessing data in a share.
Resource limit exceeded errors
Issue: Your query on a shared table returns the error RESOURCE_LIMIT_EXCEEDED
.
You may see either of these errors:
"RESOURCE_LIMIT_EXCEEDED","message":"The table metadata size exceeded limits"
"RESOURCE_LIMIT_EXCEEDED","message":"The number of files in the table to return exceeded limits, consider contact your provider to optimize the table"
Possible causes: There are limits on the number of files in metadata allowed for a shared table.
Recommended fix: To learn how to resolve either of these issues, see RESOURCE_LIMIT_EXCEEDED error when querying a Delta Sharing table in the Databricks Knowledge Base.
File not found or certificate errors
Issue: You see an error message that throws a file not found or certificate exception.
Spark error example:
FileReadException: Error while reading file delta-sharing:/%252Ftmp%252Fexample.share%2523example.tpc_ds.example/XXXXXXXXXXXXX/XXXXXXXX.
Caused by: SSLPeerUnverifiedException: Certificate for - <[workspace name].cloud.databricks.com.s3.us-east-1.amazonaws.com> doesn't match any of the subject alternative names [s3.amazonaws.com, *.s3.amazonaws.com…]:
Pandas error example:
FileNotFoundError(path)
FileNotFoundError: https://xxxx.xxxxxx.s3.xx-xxxx-1.amazonaws.com/xxxxxx/part-00000-xxxxx-Amz-Algorithm=Axxxxxx-Amz-Date=xxxxxxxx&X-Amz-SignedHeaders=host&X-Amz-Expires=xxx&X-Amz-Credential=xxxxxxx_request&X-Amz-Signature=xxxxx
Power BI error example:
DataSource.Error: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.
Details:
https://xxxx.xxxxxxxxx.s3.xx-xxxx-1.amazonaws.com/xxxxxxxx/part-00000-xxxxxxx.snappy.parquet
Possible cause: Typically you see this error because your bucket name uses dot or period notation (for example, incorrect.bucket.name.notation
). This is an AWS limitation. See the AWS bucket naming rules.
You may get this error even if your bucket name is formatted correctly. For example, you may encounter an SSL error (SSLCertVerificationError
) when you execute code on PyCharm.
Recommended fix If your bucket name uses invalid AWS bucket naming notation, use a different bucket for Unity Catalog and Delta Sharing.
If your bucket uses valid naming conventions and you still face a FileNotFoundError
in Python, enable debug logging to help isolate the issue:
import logging
logging.basicConfig(level=logging.DEBUG)