/AWS1/CL_RSH=>RESTOREFROMCLUSTERSNAPSHOT()

About RestoreFromClusterSnapshot

Creates a new cluster from a snapshot. By default, Amazon Redshift creates the resulting cluster with the same configuration as the original cluster from which the snapshot was created, except that the new cluster is created with the default cluster security and parameter groups. After Amazon Redshift creates the cluster, you can use the ModifyCluster API to associate a different security group and different parameter group with the restored cluster. If you are using a DS node type, you can also choose to change to another DS node type of the same size during restore.

If you restore a cluster into a VPC, you must provide a cluster subnet group where you want the cluster restored.

For more information about working with snapshots, go to Amazon Redshift Snapshots in the Amazon Redshift Cluster Management Guide.

Method Signature

IMPORTING

Required arguments:

IV_CLUSTERIDENTIFIER TYPE /AWS1/RSHSTRING /AWS1/RSHSTRING

The identifier of the cluster that will be created from restoring the snapshot.

Constraints:

• Must contain from 1 to 63 alphanumeric characters or hyphens.

• Alphabetic characters must be lowercase.

• First character must be a letter.

• Cannot end with a hyphen or contain two consecutive hyphens.

• Must be unique for all clusters within an Amazon Web Services account.

Optional arguments:

IV_SNAPSHOTIDENTIFIER TYPE /AWS1/RSHSTRING /AWS1/RSHSTRING

The name of the snapshot from which to create the new cluster. This parameter isn't case sensitive. You must specify this parameter or snapshotArn, but not both.

Example: my-snapshot-id

IV_SNAPSHOTARN TYPE /AWS1/RSHSTRING /AWS1/RSHSTRING

The Amazon Resource Name (ARN) of the snapshot associated with the message to restore from a cluster. You must specify this parameter or snapshotIdentifier, but not both.

IV_SNAPSHOTCLUSTERIDENTIFIER TYPE /AWS1/RSHSTRING /AWS1/RSHSTRING

The name of the cluster the source snapshot was created from. This parameter is required if your IAM user has a policy containing a snapshot resource element that specifies anything other than * for the cluster name.

IV_PORT TYPE /AWS1/RSHINTEGEROPTIONAL /AWS1/RSHINTEGEROPTIONAL

The port number on which the cluster accepts connections.

Default: The same port as the original cluster.

Valid values: For clusters with ds2 or dc2 nodes, must be within the range 1150-65535. For clusters with ra3 nodes, must be within the ranges 5431-5455 or 8191-8215.

IV_AVAILABILITYZONE TYPE /AWS1/RSHSTRING /AWS1/RSHSTRING

The Amazon EC2 Availability Zone in which to restore the cluster.

Default: A random, system-chosen Availability Zone.

Example: us-east-2a

IV_ALLOWVERSIONUPGRADE TYPE /AWS1/RSHBOOLEANOPTIONAL /AWS1/RSHBOOLEANOPTIONAL

If true, major version upgrades can be applied during the maintenance window to the Amazon Redshift engine that is running on the cluster.

Default: true

IV_CLUSTERSUBNETGROUPNAME TYPE /AWS1/RSHSTRING /AWS1/RSHSTRING

The name of the subnet group where you want to cluster restored.

A snapshot of cluster in VPC can be restored only in VPC. Therefore, you must provide subnet group name where you want the cluster restored.

IV_PUBLICLYACCESSIBLE TYPE /AWS1/RSHBOOLEANOPTIONAL /AWS1/RSHBOOLEANOPTIONAL

If true, the cluster can be accessed from a public network.

IV_OWNERACCOUNT TYPE /AWS1/RSHSTRING /AWS1/RSHSTRING

The Amazon Web Services account used to create or copy the snapshot. Required if you are restoring a snapshot you do not own, optional if you own the snapshot.

IV_HSMCLIENTCERTIDENTIFIER TYPE /AWS1/RSHSTRING /AWS1/RSHSTRING

Specifies the name of the HSM client certificate the Amazon Redshift cluster uses to retrieve the data encryption keys stored in an HSM.

IV_HSMCONFIDENTIFIER TYPE /AWS1/RSHSTRING /AWS1/RSHSTRING

Specifies the name of the HSM configuration that contains the information the Amazon Redshift cluster can use to retrieve and store keys in an HSM.

IV_ELASTICIP TYPE /AWS1/RSHSTRING /AWS1/RSHSTRING

The Elastic IP (EIP) address for the cluster. Don't specify the Elastic IP address for a publicly accessible cluster with availability zone relocation turned on.

IV_CLUSTERPARAMETERGROUPNAME TYPE /AWS1/RSHSTRING /AWS1/RSHSTRING

The name of the parameter group to be associated with this cluster.

Default: The default Amazon Redshift cluster parameter group. For information about the default parameter group, go to Working with Amazon Redshift Parameter Groups.

Constraints:

• Must be 1 to 255 alphanumeric characters or hyphens.

• First character must be a letter.

• Cannot end with a hyphen or contain two consecutive hyphens.

IT_CLUSTERSECURITYGROUPS TYPE /AWS1/CL_RSHCLSTSECGRNAMELST_W=>TT_CLUSTERSECGROUPNAMELIST TT_CLUSTERSECGROUPNAMELIST

A list of security groups to be associated with this cluster.

Default: The default cluster security group for Amazon Redshift.

Cluster security groups only apply to clusters outside of VPCs.

IT_VPCSECURITYGROUPIDS TYPE /AWS1/CL_RSHVPCSECGRPIDLIST_W=>TT_VPCSECURITYGROUPIDLIST TT_VPCSECURITYGROUPIDLIST

A list of Virtual Private Cloud (VPC) security groups to be associated with the cluster.

Default: The default VPC security group is associated with the cluster.

VPC security groups only apply to clusters in VPCs.

IV_PREFERREDMAINTENANCEWIN00 TYPE /AWS1/RSHSTRING /AWS1/RSHSTRING

The weekly time range (in UTC) during which automated cluster maintenance can occur.

Format: ddd:hh24:mi-ddd:hh24:mi

Default: The value selected for the cluster from which the snapshot was taken. For more information about the time blocks for each region, see Maintenance Windows in Amazon Redshift Cluster Management Guide.

Valid Days: Mon | Tue | Wed | Thu | Fri | Sat | Sun

Constraints: Minimum 30-minute window.

IV_AUTOMATEDSNAPRETPERIOD TYPE /AWS1/RSHINTEGEROPTIONAL /AWS1/RSHINTEGEROPTIONAL

The number of days that automated snapshots are retained. If the value is 0, automated snapshots are disabled. Even if automated snapshots are disabled, you can still create manual snapshots when you want with CreateClusterSnapshot.

You can't disable automated snapshots for RA3 node types. Set the automated retention period from 1-35 days.

Default: The value selected for the cluster from which the snapshot was taken.

Constraints: Must be a value from 0 to 35.

IV_MANUALSNAPSHOTRETPERIOD TYPE /AWS1/RSHINTEGEROPTIONAL /AWS1/RSHINTEGEROPTIONAL

The default number of days to retain a manual snapshot. If the value is -1, the snapshot is retained indefinitely. This setting doesn't change the retention period of existing snapshots.

The value must be either -1 or an integer between 1 and 3,653.

IV_KMSKEYID TYPE /AWS1/RSHSTRING /AWS1/RSHSTRING

The Key Management Service (KMS) key ID of the encryption key that encrypts data in the cluster restored from a shared snapshot. You can also provide the key ID when you restore from an unencrypted snapshot to an encrypted cluster in the same account. Additionally, you can specify a new KMS key ID when you restore from an encrypted snapshot in the same account in order to change it. In that case, the restored cluster is encrypted with the new KMS key ID.

IV_NODETYPE TYPE /AWS1/RSHSTRING /AWS1/RSHSTRING

The node type that the restored cluster will be provisioned with.

Default: The node type of the cluster from which the snapshot was taken. You can modify this if you are using any DS node type. In that case, you can choose to restore into another DS node type of the same size. For example, you can restore ds1.8xlarge into ds2.8xlarge, or ds1.xlarge into ds2.xlarge. If you have a DC instance type, you must restore into that same instance type and size. In other words, you can only restore a dc1.large instance type into another dc1.large instance type or dc2.large instance type. You can't restore dc1.8xlarge to dc2.8xlarge. First restore to a dc1.8xlarge cluster, then resize to a dc2.8large cluster. For more information about node types, see About Clusters and Nodes in the Amazon Redshift Cluster Management Guide.

IV_ENHANCEDVPCROUTING TYPE /AWS1/RSHBOOLEANOPTIONAL /AWS1/RSHBOOLEANOPTIONAL

An option that specifies whether to create the cluster with enhanced VPC routing enabled. To create a cluster that uses enhanced VPC routing, the cluster must be in a VPC. For more information, see Enhanced VPC Routing in the Amazon Redshift Cluster Management Guide.

If this option is true, enhanced VPC routing is enabled.

Default: false

IV_ADDITIONALINFO TYPE /AWS1/RSHSTRING /AWS1/RSHSTRING

Reserved.

IT_IAMROLES TYPE /AWS1/CL_RSHIAMROLEARNLIST_W=>TT_IAMROLEARNLIST TT_IAMROLEARNLIST

A list of Identity and Access Management (IAM) roles that can be used by the cluster to access other Amazon Web Services services. You must supply the IAM roles in their Amazon Resource Name (ARN) format.

The maximum number of IAM roles that you can associate is subject to a quota. For more information, go to Quotas and limits in the Amazon Redshift Cluster Management Guide.

IV_MAINTENANCETRACKNAME TYPE /AWS1/RSHSTRING /AWS1/RSHSTRING

The name of the maintenance track for the restored cluster. When you take a snapshot, the snapshot inherits the MaintenanceTrack value from the cluster. The snapshot might be on a different track than the cluster that was the source for the snapshot. For example, suppose that you take a snapshot of a cluster that is on the current track and then change the cluster to be on the trailing track. In this case, the snapshot and the source cluster are on different tracks.

IV_SNAPSHOTSCHEDULEID TYPE /AWS1/RSHSTRING /AWS1/RSHSTRING

A unique identifier for the snapshot schedule.

IV_NUMBEROFNODES TYPE /AWS1/RSHINTEGEROPTIONAL /AWS1/RSHINTEGEROPTIONAL

The number of nodes specified when provisioning the restored cluster.

IV_AZRELOCATION TYPE /AWS1/RSHBOOLEANOPTIONAL /AWS1/RSHBOOLEANOPTIONAL

The option to enable relocation for an Amazon Redshift cluster between Availability Zones after the cluster is restored.

IV_AQUACONFIGURATIONSTATUS TYPE /AWS1/RSHAQUACONFSTATUS /AWS1/RSHAQUACONFSTATUS

This parameter is retired. It does not set the AQUA configuration status. Amazon Redshift automatically determines whether to use AQUA (Advanced Query Accelerator).

IV_DEFAULTIAMROLEARN TYPE /AWS1/RSHSTRING /AWS1/RSHSTRING

The Amazon Resource Name (ARN) for the IAM role that was set as default for the cluster when the cluster was last modified while it was restored from a snapshot.

IV_RESERVEDNODEID TYPE /AWS1/RSHSTRING /AWS1/RSHSTRING

The identifier of the target reserved node offering.

IV_TARGETRSVDNODEOFFERINGID TYPE /AWS1/RSHSTRING /AWS1/RSHSTRING

The identifier of the target reserved node offering.

IV_ENCRYPTED TYPE /AWS1/RSHBOOLEANOPTIONAL /AWS1/RSHBOOLEANOPTIONAL

Enables support for restoring an unencrypted snapshot to a cluster encrypted with Key Management Service (KMS) and a customer managed key.

IV_MANAGEMASTERPASSWORD TYPE /AWS1/RSHBOOLEANOPTIONAL /AWS1/RSHBOOLEANOPTIONAL

If true, Amazon Redshift uses Secrets Manager to manage the restored cluster's admin credentials. If ManageMasterPassword is false or not set, Amazon Redshift uses the admin credentials the cluster had at the time the snapshot was taken.

IV_MASTERPASSWORDSECRETKMS00 TYPE /AWS1/RSHSTRING /AWS1/RSHSTRING

The ID of the Key Management Service (KMS) key used to encrypt and store the cluster's admin credentials secret. You can only use this parameter if ManageMasterPassword is true.

IV_IPADDRESSTYPE TYPE /AWS1/RSHSTRING /AWS1/RSHSTRING

The IP address type for the cluster. Possible values are ipv4 and dualstack.

IV_MULTIAZ TYPE /AWS1/RSHBOOLEANOPTIONAL /AWS1/RSHBOOLEANOPTIONAL

If true, the snapshot will be restored to a cluster deployed in two Availability Zones.

RETURNING

OO_OUTPUT TYPE REF TO /AWS1/CL_RSHRESTOREFRMCLSTSN01 /AWS1/CL_RSHRESTOREFRMCLSTSN01