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.

File not found or certificate errors

Issue: You see an error message that throws a file not found or certificate exception.

Possible cause: 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.

Recommended fix: Use a different bucket for Unity Catalog and Delta Sharing.

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