Can provisioned Redshift clusters and Serverless Redshift clusters share data when they are in the same region and under the same account?

on

 Yes, provisioned Redshift clusters and Serverless Redshift clusters can share data when they are in the same region and under the same account. However, there are some requirements and limitations to consider:

  1. The Redshift clusters must be in the same AWS account and in the same region.
  2. Both clusters must be running Redshift version 1.0.15663 or later.
  3. The data sharing feature must be enabled in both clusters.
  4. The namespace IDs of the consumer cluster (Serverless Redshift) must be added to the producer cluster's (provisioned Redshift) data share configuration.
  5. The schemas and tables that are shared must be visible to both clusters.
  6. The tables being shared must not have any column-level constraints or triggers that prevent data modifications.

Based on your description, it seems that you have correctly configured the data share in the provisioned Redshift cluster and added the consumer namespace ID of the Serverless Redshift cluster. However, the DESC DATASHARE command is not returning the list of schemas and tables registered for data sharing. This could be due to several reasons:

  1. The data share may not have been activated yet. It may take a few minutes for the data share to become active after it is created.
  2. The schemas and tables that are being shared may not be visible to the Serverless Redshift cluster. Check that the schemas and tables are accessible to the Serverless Redshift cluster's IAM role or user.
  3. The version of Redshift running in the Serverless cluster may not be compatible with the data sharing feature. Make sure that the Serverless Redshift cluster is running version 1.0.15663 or later.
  4. There may be a typo or error in the command syntax. Double-check the command syntax and try again.

If none of these solutions work, you can try contacting AWS support for further assistance.

Comments

Post a Comment