/AWS1/CL_RSH=>CREATECLUSTER()
¶
About CreateCluster¶
Creates a new cluster with the specified parameters.
To create a cluster in Virtual Private Cloud (VPC), you must provide a cluster subnet group name. The cluster subnet group identifies the subnets of your VPC that Amazon Redshift uses when creating the cluster. For more information about managing clusters, go to Amazon Redshift Clusters in the Amazon Redshift Cluster Management Guide.
Method Signature¶
IMPORTING¶
Required arguments:¶
IV_CLUSTERIDENTIFIER
TYPE /AWS1/RSHSTRING
/AWS1/RSHSTRING
¶
A unique identifier for the cluster. You use this identifier to refer to the cluster for any subsequent cluster operations such as deleting or modifying. The identifier also appears in the Amazon Redshift console.
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.
Example:
myexamplecluster
IV_NODETYPE
TYPE /AWS1/RSHSTRING
/AWS1/RSHSTRING
¶
The node type to be provisioned for the cluster. For information about node types, go to Working with Clusters in the Amazon Redshift Cluster Management Guide.
Valid Values:
ds2.xlarge
|ds2.8xlarge
|dc1.large
|dc1.8xlarge
|dc2.large
|dc2.8xlarge
|ra3.xlplus
|ra3.4xlarge
|ra3.16xlarge
IV_MASTERUSERNAME
TYPE /AWS1/RSHSTRING
/AWS1/RSHSTRING
¶
The user name associated with the admin user account for the cluster that is being created.
Constraints:
Must be 1 - 128 alphanumeric characters or hyphens. The user name can't be
PUBLIC
.Must contain only lowercase letters, numbers, underscore, plus sign, period (dot), at symbol (@), or hyphen.
The first character must be a letter.
Must not contain a colon (:) or a slash (/).
Cannot be a reserved word. A list of reserved words can be found in Reserved Words in the Amazon Redshift Database Developer Guide.
Optional arguments:¶
IV_DBNAME
TYPE /AWS1/RSHSTRING
/AWS1/RSHSTRING
¶
The name of the first database to be created when the cluster is created.
To create additional databases after the cluster is created, connect to the cluster with a SQL client and use SQL commands to create a database. For more information, go to Create a Database in the Amazon Redshift Database Developer Guide.
Default:
dev
Constraints:
Must contain 1 to 64 alphanumeric characters.
Must contain only lowercase letters.
Cannot be a word that is reserved by the service. A list of reserved words can be found in Reserved Words in the Amazon Redshift Database Developer Guide.
IV_CLUSTERTYPE
TYPE /AWS1/RSHSTRING
/AWS1/RSHSTRING
¶
The type of the cluster. When cluster type is specified as
single-node
, the NumberOfNodes parameter is not required.
multi-node
, the NumberOfNodes parameter is required.Valid Values:
multi-node
|single-node
Default:
multi-node
IV_MASTERUSERPASSWORD
TYPE /AWS1/RSHSENSITIVESTRING
/AWS1/RSHSENSITIVESTRING
¶
The password associated with the admin user account for the cluster that is being created.
You can't use
MasterUserPassword
ifManageMasterPassword
istrue
.Constraints:
Must be between 8 and 64 characters in length.
Must contain at least one uppercase letter.
Must contain at least one lowercase letter.
Must contain one number.
Can be any printable ASCII character (ASCII code 33-126) except
'
(single quote),"
(double quote),\
,/
, or@
.
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.
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.
IV_CLUSTERSUBNETGROUPNAME
TYPE /AWS1/RSHSTRING
/AWS1/RSHSTRING
¶
The name of a cluster subnet group to be associated with this cluster.
If this parameter is not provided the resulting cluster will be deployed outside virtual private cloud (VPC).
IV_AVAILABILITYZONE
TYPE /AWS1/RSHSTRING
/AWS1/RSHSTRING
¶
The EC2 Availability Zone (AZ) in which you want Amazon Redshift to provision the cluster. For example, if you have several EC2 instances running in a specific Availability Zone, then you might want the cluster to be provisioned in the same zone in order to decrease network latency.
Default: A random, system-chosen Availability Zone in the region that is specified by the endpoint.
Example:
us-east-2d
Constraint: The specified Availability Zone must be in the same region as the current endpoint.
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: A 30-minute window selected at random from an 8-hour block of time per region, occurring on a random day of the week. 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_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.
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:
1
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_PORT
TYPE /AWS1/RSHINTEGEROPTIONAL
/AWS1/RSHINTEGEROPTIONAL
¶
The port number on which the cluster accepts incoming connections.
The cluster is accessible only via the JDBC and ODBC connection strings. Part of the connection string requires the port on which the cluster will listen for incoming connections.
Default:
5439
Valid Values:
For clusters with ra3 nodes - Select a port within the ranges
5431-5455
or8191-8215
. (If you have an existing cluster with ra3 nodes, it isn't required that you change the port to these ranges.)For clusters with ds2 or dc2 nodes - Select a port within the range
1150-65535
.
IV_CLUSTERVERSION
TYPE /AWS1/RSHSTRING
/AWS1/RSHSTRING
¶
The version of the Amazon Redshift engine software that you want to deploy on the cluster.
The version selected runs on all the nodes in the cluster.
Constraints: Only version 1.0 is currently available.
Example:
1.0
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.When a new major version of the Amazon Redshift engine is released, you can request that the service automatically apply upgrades during the maintenance window to the Amazon Redshift engine that is running on your cluster.
Default:
true
IV_NUMBEROFNODES
TYPE /AWS1/RSHINTEGEROPTIONAL
/AWS1/RSHINTEGEROPTIONAL
¶
The number of compute nodes in the cluster. This parameter is required when the ClusterType parameter is specified as
multi-node
.For information about determining how many nodes you need, go to Working with Clusters in the Amazon Redshift Cluster Management Guide.
If you don't specify this parameter, you get a single-node cluster. When requesting a multi-node cluster, you must specify the number of nodes that you want in the cluster.
Default:
1
Constraints: Value must be at least 1 and no more than 100.
IV_PUBLICLYACCESSIBLE
TYPE /AWS1/RSHBOOLEANOPTIONAL
/AWS1/RSHBOOLEANOPTIONAL
¶
If
true
, the cluster can be accessed from a public network.
IV_ENCRYPTED
TYPE /AWS1/RSHBOOLEANOPTIONAL
/AWS1/RSHBOOLEANOPTIONAL
¶
If
true
, the data in the cluster is encrypted at rest.Default: false
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.
Constraints: The cluster must be provisioned in EC2-VPC and publicly-accessible through an Internet gateway. Don't specify the Elastic IP address for a publicly accessible cluster with availability zone relocation turned on. For more information about provisioning clusters in EC2-VPC, go to Supported Platforms to Launch Your Cluster in the Amazon Redshift Cluster Management Guide.
IT_TAGS
TYPE /AWS1/CL_RSHTAG=>TT_TAGLIST
TT_TAGLIST
¶
A list of tag instances.
IV_KMSKEYID
TYPE /AWS1/RSHSTRING
/AWS1/RSHSTRING
¶
The Key Management Service (KMS) key ID of the encryption key that you want to use to encrypt data in the cluster.
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
¶
An optional parameter for the name of the maintenance track for the cluster. If you don't provide a maintenance track name, the cluster is assigned to the
current
track.
IV_SNAPSHOTSCHEDULEID
TYPE /AWS1/RSHSTRING
/AWS1/RSHSTRING
¶
A unique identifier for the snapshot schedule.
IV_AZRELOCATION
TYPE /AWS1/RSHBOOLEANOPTIONAL
/AWS1/RSHBOOLEANOPTIONAL
¶
The option to enable relocation for an Amazon Redshift cluster between Availability Zones after the cluster is created.
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 created.
IV_LOADSAMPLEDATA
TYPE /AWS1/RSHSTRING
/AWS1/RSHSTRING
¶
A flag that specifies whether to load sample data once the cluster is created.
IV_MANAGEMASTERPASSWORD
TYPE /AWS1/RSHBOOLEANOPTIONAL
/AWS1/RSHBOOLEANOPTIONAL
¶
If
true
, Amazon Redshift uses Secrets Manager to manage this cluster's admin credentials. You can't useMasterUserPassword
ifManageMasterPassword
is true. IfManageMasterPassword
is false or not set, Amazon Redshift usesMasterUserPassword
for the admin user account's password.
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 types that the cluster supports. Possible values are
ipv4
anddualstack
.
IV_MULTIAZ
TYPE /AWS1/RSHBOOLEANOPTIONAL
/AWS1/RSHBOOLEANOPTIONAL
¶
If true, Amazon Redshift will deploy the cluster in two Availability Zones (AZ).
IV_REDSHIFTIDCAPPLICATIONARN
TYPE /AWS1/RSHSTRING
/AWS1/RSHSTRING
¶
The Amazon resource name (ARN) of the Amazon Redshift IAM Identity Center application.