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
arn:aws:iam::aws:policy/AdministratorAccess
or the full Amazon Redshift permission
arn:aws:iam::aws:policy/AmazonRedshiftFullAccess
is attached to the IAM policy that you used. If true, then open a Support Ticket for assistance.
Relevant questions
Redshift Serverless is missing Geospacial data types
asked 6 months agoRestore encrypted Snapshot
asked a month agoCDK: How to restore a Redshift from a Snapshot ?
asked 2 months agoRestoring Redshift Schema (only schema no data)form Prod cluster to non-prod cluster
asked 4 months agoHow to delete Redshift Serverless ?
Accepted Answerasked 5 months agorestoring redshift serverless from provisioned cluster snapshot
asked 2 months agoWhen should I use Redshift non-Serverless over Redshift Serverless?
asked 7 months agoMigration from Aurora to Aurora Serverless?
Accepted Answerasked 3 years agoUnable to restore Aurora Serverless V1 snapshot to Aurora Provisioned
Accepted Answerasked 3 months ago(Serverless) Amazon Aurora MySQL 1 end of life on February 28, 2023
asked 3 months ago
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.