restoring redshift serverless from provisioned cluster snapshot
I recently enabled redshift serverless endpoint, and to benchmark it I want to restore it from a snapshot of a legacy provisioned cluster, so we have identical data sets to start with. However, when I select to restore the snapshot to the serverless (using console as described in https://docs.aws.amazon.com/redshift/latest/mgmt/serverless-snapshots-recovery.html, and confirming that it will replace all my serverless databases), nothing seems to happen (no error, but also the serverless databases are not replaced with the snapshot).
I already tried adding redshift full access policy to the IAM role of the serverless endpoint, but that didn't help.
Has anyone already achieved this?
Kindly review that either the administrator permission
or the full Amazon Redshift permission
is attached to the IAM policy that you used. If true, then open a Support Ticket for assistance.
As indicated in my initial post, I have already attached both the arn:aws:iam::aws:policy/AmazonRedshiftFullAccess and the arn:aws:iam::aws:policy/AmazonRedshiftDataFullAccess policies to the IAM role, but that did not make any difference.
Redshift Serverless is missing Geospacial data typesasked 6 months ago
Restore encrypted Snapshotasked a month ago
CDK: How to restore a Redshift from a Snapshot ?asked 2 months ago
Restoring Redshift Schema (only schema no data)form Prod cluster to non-prod clusterasked 4 months ago
How to delete Redshift Serverless ?Accepted Answerasked 5 months ago
restoring redshift serverless from provisioned cluster snapshotasked 2 months ago
When should I use Redshift non-Serverless over Redshift Serverless?asked 7 months ago
Migration from Aurora to Aurora Serverless?Accepted Answerasked 3 years ago
Unable to restore Aurora Serverless V1 snapshot to Aurora ProvisionedAccepted Answerasked 3 months ago
(Serverless) Amazon Aurora MySQL 1 end of life on February 28, 2023asked 3 months ago