Access error for data sourcing despite access and subscription

Q&A
, , , ,
1

Despite having access and subscribed through every single target on Data central, I still get an access error.

Error is as following: Error details

region: us-east-1
timestamp: 1785941529661
requestId: b780e415-e300-4055-8fd8-6a199ee0c60c
sourceErrorCode: 0
sourceErrorMessage: ERROR: Datasharing Error: Unauthorized
sourceErrorState: XX000
sourceException: spaceneedlejarjar.redshift21.com.amazon.redshift.util.RedshiftException
sourceType: REDSHIFT

Kindly asking for assistance on this.

2

Hi @muhcosk

Welcome to the Quick community!

The Datasharing Error: Unauthorized error indicates that while your Data Central subscription is in place, the underlying Redshift datashare authorization chain may be incomplete. This typically requires the data producer team (the dataset owner in Data Central) to verify the following on their end:

  1. The datashare has been authorized for your account/namespace.
  2. Your cluster/workgroup has been properly associated with the datashare.
  3. A database has been created from the datashare with appropriate USAGE grants.

Could you please reach out to the data producer team and ask them to confirm that the datashare status shows as Active for your namespace? It would also be helpful to share your Redshift cluster/workgroup ARN and AWS account ID with them so they can verify the authorization on their side.

For additional reference, the following official documentation covers the datashare authorization process in detail.