Initialize connection to Redshift
options parameter must include values for :aws_access_key_id and :aws_secret_access_key in order to create a connection
ses = SES.new( :aws_access_key_id => your_aws_access_key_id, :aws_secret_access_key => your_aws_secret_access_key )
@param [Hash] options
The name of the security Group from which to revoke the ingress rule.
The IP range for which to revoke access. This range must be a valid Classless Inter-Domain Routing (CIDR) block of IP addresses. If CIDRIP is specified, EC2SecurityGroupName and EC2SecurityGroupOwnerId cannot be provided.
The name of the EC2 Security Group whose access is to be revoked. If EC2SecurityGroupName is specified, EC2SecurityGroupOwnerId must also be provided and CIDRIP cannot be provided.
The AWS account number of the owner of the security group specified in the EC2SecurityGroupName parameter. The AWS access key ID is not an acceptable value. If EC2SecurityGroupOwnerId is specified, EC2SecurityGroupName must also be provided. and CIDRIP cannot be provided. Example: 111122223333
docs.aws.amazon.com/redshift/latest/APIReference/API_AuthorizeClusterSecurityGroupIngress.html
@param [Hash] options
The identifier of the snapshot the account is authorized to restore.
The identifier of the AWS customer account authorized to restore the specified snapshot. #
docs.aws.amazon.com/redshift/latest/APIReference/API_CopyClusterSnapshot.html
@param [Hash] options
The identifier for the source snapshot. Constraints: Must be the identifier for a valid automated snapshot whose state is "available".
The identifier given to the new manual snapshot. Constraints: Cannot be null, empty, or blank. Must contain from 1 to 255 alphanumeric characters or hyphens. First character must be a letter. Cannot end with a hyphen or contain two consecutive hyphens. Must be unique for the AWS account that is making the request.
docs.aws.amazon.com/redshift/latest/APIReference/API_CopyClusterSnapshot.html
@param [Hash] options
The name of the cluster parameter group. 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. Must be unique within your AWS account. This value is stored as a lower-case string.
The Amazon Redshift engine version to which the cluster parameter group applies. The cluster engine version determines the set of parameters. To get a list of valid parameter group family names, you can call DescribeClusterParameterGroups. By default, Amazon Redshift returns a list of all the parameter groups that are owned by your AWS account, including the default parameter groups for each Amazon Redshift engine version. The parameter group family names associated with the default parameter groups provide you the valid values. For example, a valid family name is "redshift-1.0".
A description of the parameter group.
docs.aws.amazon.com/redshift/latest/APIReference/API_CreateClusterParameterGroup.html
@param [Hash] options
The name of a cluster security group for which you are requesting details. You can specify either the Marker parameter or a ClusterSecurityGroupName parameter, but not both. Example: securitygroup1
A description for the security group.
docs.aws.amazon.com/redshift/latest/APIReference/API_CreateClusterSecurityGroup.html
@param [Hash] options
A unique identifier for the snapshot that you are requesting. This identifier must be unique for all snapshots within the AWS account. Constraints: Cannot be null, empty, or blank Must contain from 1 to 255 alphanumeric characters or hyphens First character must be a letter Cannot end with a hyphen or contain two consecutive hyphens Example: my-snapshot-id
The cluster identifier for which you want a snapshot.
docs.aws.amazon.com/redshift/latest/APIReference/API_CreateClusterSnapshot.html
@param [Hash] options
The name for the subnet group. Amazon Redshift stores the value as a lowercase string. Constraints: Must contain no more than 255 alphanumeric characters or hyphens. Must not be "Default". Must be unique for all subnet groups that are created by your AWS account. Example: examplesubnetgroup
A description of the parameter group.
An array of VPC subnet IDs. A maximum of 20 subnets can be modified in a single request.
docs.aws.amazon.com/redshift/latest/APIReference/API_CreateClusterSubnetGroup.html
@param [Hash] options
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. Must be unique for all clusters within an AWS account. Example: myexamplecluster
Determines whether a final snapshot of the cluster is created before Amazon Redshift deletes the cluster. If `true` , a final cluster snapshot is not created. If `false`, a final cluster snapshot is created before the cluster is deleted. The FinalClusterSnapshotIdentifier parameter must be specified if SkipFinalClusterSnapshot is `false` . Default: `false`
The identifier of the final snapshot that is to be created immediately before deleting the cluster. If this parameter is provided, SkipFinalClusterSnapshot must be `false`. Constraints: Must be 1 to 255 alphanumeric characters. First character must be a letter Cannot end with a hyphen or contain two consecutive hyphens.
docs.aws.amazon.com/redshift/latest/APIReference/API_DeleteCluster.html
@param [Hash] options
The name of the parameter group to be deleted. Constraints: Must be the name of an existing cluster parameter group. Cannot delete a default cluster parameter group.
docs.aws.amazon.com/redshift/latest/APIReference/API_DeleteClusterParameterGroup.html
@param [Hash] options
The name of the cluster security group to be deleted.
docs.aws.amazon.com/redshift/latest/APIReference/API_DeleteClusterSecurityGroup.html
@param [Hash] options
A unique identifier for the snapshot that you are requesting. This identifier must be unique for all snapshots within the AWS account. Constraints: Cannot be null, empty, or blank Must contain from 1 to 255 alphanumeric characters or hyphens First character must be a letter Cannot end with a hyphen or contain two consecutive hyphens Example: my-snapshot-id
The cluster identifier for which you want a snapshot.
docs.aws.amazon.com/redshift/latest/APIReference/API_CreateClusterSnapshot.html
@param [Hash] options
The name for the subnet group. Amazon Redshift stores the value as a lowercase string. Constraints: Must contain no more than 255 alphanumeric characters or hyphens. Must not be "Default". Must be unique for all subnet groups that are created by your AWS account. Example: examplesubnetgroup
docs.aws.amazon.com/redshift/latest/APIReference/API_DeleteClusterSubnetGroup.html
@param [Hash] options
The name of a cluster parameter group for which to return details.
The maximum number of records to include in the response. If more than the MaxRecords value is available, a marker is included in the response so that the following results can be retrieved. Constrained between [20,100]. Default is 100.
The marker returned from a previous request. If this parameter is specified, the response includes records beyond the marker only, up to MaxRecords.
docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeClusterParameterGroups.html
@param [Hash] options
The name of a cluster parameter group for which to return details.
The parameter types to return. Specify user to show parameters that are different form the default. Similarly, specify engine-default to show parameters that are the same as the default parameter group. Default: All parameter types returned. Valid Values: user | engine-default
The maximum number of records to include in the response. If more than the MaxRecords value is available, a marker is included in the response so that the following results can be retrieved. Constrained between [20,100]. Default is 100.
The marker returned from a previous request. If this parameter is specified, the response includes records beyond the marker only, up to MaxRecords.
docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeClusterParameters.html
@param [Hash] options
The name of a cluster security group for which you are requesting details. You can specify either the Marker parameter or a ClusterSecurityGroupName parameter, but not both. Example: securitygroup1
The maximum number of records to include in the response. If more than the MaxRecords value is available, a marker is included in the response so that the following results can be retrieved. Constrained between [20,100]. Default is 100.
The marker returned from a previous request. If this parameter is specified, the response includes records beyond the marker only, up to MaxRecords.
docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeClusterSecurityGroups.html
@param [Hash] options
The identifier of the cluster for which information about snapshots is requested.
The snapshot identifier of the snapshot about which to return information.
The type of snapshots for which you are requesting information. By default, snapshots of all types are returned. Valid Values: automated | manual
A value that requests only snapshots created at or after the specified time. The time value is specified in ISO 8601 format. For more information about ISO 8601, go to the ISO8601 Wikipedia page. Example: 2012-07-16T18:00:00Z
A time value that requests only snapshots created at or before the specified time. The time value is specified in ISO 8601 format. For more information about ISO 8601, go to the ISO8601 Wikipedia page. Example: 2012-07-16T18:00:00Z
The AWS customer account used to create or copy the snapshot. Use this field to filter the results to snapshots owned by a particular account. To describe snapshots you own, either specify your AWS customer account, or do not specify the parameter.
The maximum number of records to include in the response. If more than the MaxRecords value is available, a marker is included in the response so that the following results can be retrieved. Constrained between [20,100]. Default is 100.
The marker returned from a previous request. If this parameter is specified, the response includes records beyond the marker only, up to MaxRecords.
docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeClusterSnapshots.html
@param [Hash] options
The name of the cluster subnet group for which information is requested.
The maximum number of records to include in the response. If more than the MaxRecords value is available, a marker is included in the response so that the following results can be retrieved. Constrained between [20,100]. Default is 100.
The marker returned from a previous request. If this parameter is specified, the response includes records beyond the marker only, up to MaxRecords.
docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeClusterSubnetGroups.html
@param [Hash] options
The name of a specific cluster parameter group family to return details for. Constraints: Must be 1 to 255 alphanumeric characters. First character must be a letter, and cannot end with a hyphen or contain two consecutive hyphens.
The specific cluster version to return. Example: 1.0
The maximum number of records to include in the response. If more than the MaxRecords value is available, a marker is included in the response so that the following results can be retrieved. Constrained between [20,100]. Default is 100.
The marker returned from a previous request. If this parameter is specified, the response includes records beyond the marker only, up to MaxRecords.
docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeClusterVersions.html
@param [Hash] options
The unique identifier of a cluster whose properties you are requesting. This parameter isn't case sensitive. The default is that all clusters defined for an account are returned.
The maximum number of records to include in the response. If more than the MaxRecords value is available, a marker is included in the response so that the following results can be retrieved. Constrained between [20,100]. Default is 100.
The marker returned from a previous request. If this parameter is specified, the response includes records beyond the marker only, up to MaxRecords.
docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeClusters.html
@param [Hash] options
The name of a cluster parameter group family for which to return details.
The maximum number of records to include in the response. If more than the MaxRecords value is available, a marker is included in the response so that the following results can be retrieved. Constrained between [20,100]. Default is 100.
The marker returned from a previous request. If this parameter is specified, the response includes records beyond the marker only, up to MaxRecords.
docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeDefaultClusterParameters.html
@param [Hash] options
The identifier of the event source for which events will be returned. If this parameter is not specified, then all sources are included in the response. Constraints: If SourceIdentifier is supplied, SourceType must also be provided. Specify a cluster identifier when SourceType is cluster. Specify a cluster security group name when SourceType is cluster-security-group. Specify a cluster parameter group name when SourceType is cluster-parameter-group. Specify a cluster snapshot identifier when SourceType is cluster-snapshot.
The event source to retrieve events for. If no value is specified, all events are returned. Constraints: If SourceType is supplied, SourceIdentifier must also be provided. Specify cluster when SourceIdentifier is a cluster identifier. Specify cluster-security-group when SourceIdentifier is a cluster security group name. Specify cluster-parameter-group when SourceIdentifier is a cluster parameter group name. Specify cluster-snapshot when SourceIdentifier is a cluster snapshot identifier. Valid values include: cluster, cluster-parameter-group, cluster-security-group, cluster-snapshot
The beginning of the time interval to retrieve events for, specified in ISO 8601 format. Example: 2009-07-08T18:00Z
The end of the time interval for which to retrieve events, specified in ISO 8601 format. Example: 2009-07-08T18:00Z
The number of minutes prior to the time of the request for which to retrieve events. For example, if the request is sent at 18:00 and you specify a duration of 60, then only events which have occurred after 17:00 will be returned. Default: 60
The maximum number of records to include in the response. If more than the MaxRecords value is available, a marker is included in the response so that the following results can be retrieved. Constrained between [20,100]. Default is 100.
The marker returned from a previous request. If this parameter is specified, the response includes records beyond the marker only, up to MaxRecords.
docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeEvents.html
@param [Hash] options
The version filter value. Specify this parameter to show only the available offerings matching the specified version. Default: All versions. Constraints: Must be one of the version returned from DescribeClusterVersions.
The node type filter value. Specify this parameter to show only the available offerings matching the specified node type.
The maximum number of records to include in the response. If more than the MaxRecords value is available, a marker is included in the response so that the following results can be retrieved. Constrained between [20,100]. Default is 100.
The marker returned from a previous request. If this parameter is specified, the response includes records beyond the marker only, up to MaxRecords.
docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeOrderableClusterOptions.html
@param [Hash] options
The unique identifier for the offering.
The maximum number of records to include in the response. If more than the MaxRecords value is available, a marker is included in the response so that the following results can be retrieved. Constrained between [20,100]. Default is 100.
The marker returned from a previous request. If this parameter is specified, the response includes records beyond the marker only, up to MaxRecords.
docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeReservedNodeOfferings.html
@param [Hash] options
The unique identifier for the node reservation.
The maximum number of records to include in the response. If more than the MaxRecords value is available, a marker is included in the response so that the following results can be retrieved. Constrained between [20,100]. Default is 100.
The marker returned from a previous request. If this parameter is specified, the response includes records beyond the marker only, up to MaxRecords.
docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeReservedNodes.html
@param [Hash] options
The unique identifier of a cluster whose resize progress you are requesting. This parameter isn't case-sensitive. By default, resize operations for all clusters defined for an AWS account are returned.
docs.aws.amazon.com/redshift/latest/APIReference/API_DescribeResize.html
@param [Hash] options
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. Must be unique for all clusters within an AWS account. Example: myexamplecluster
If `true` , upgrades can be applied during the maintenance window to the Amazon Redshift engine that is running on the cluster. Default: `true`
Number of days that automated snapshots are retained. If the value is 0, automated snapshots are disabled. Default: 1 Constraints: Must be a value from 0 to 35.
The name of the parameter group to be associated with this cluster. Default: The default Amazon Redshift cluster parameter group. 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.
A list of security groups to be associated with this cluster. Default: The default cluster security group for Amazon Redshift.
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
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
The password associated with the master user account for the cluster that is being created. 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.
The node type to be provisioned. Valid Values: dw.hs1.xlarge | dw.hs1.8xlarge.
The number of compute nodes in the cluster. This parameter is required when the ClusterType parameter is specified as multi-node. 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.
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. Constraints: Minimum 30-minute window.
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.
docs.aws.amazon.com/redshift/latest/APIReference/API_CreateCluster.html
@param [Hash] options
The name of the parameter group to be deleted. Constraints: Must be the name of an existing cluster parameter group. Cannot delete a default cluster parameter group.
docs.aws.amazon.com/redshift/latest/APIReference/API_ModifyClusterParameterGroup.html
@param [Hash] options
The name for the subnet group. Amazon Redshift stores the value as a lowercase string. Constraints: Must contain no more than 255 alphanumeric characters or hyphens. Must not be "Default". Must be unique for all subnet groups that are created by your AWS account. Example: examplesubnetgroup
A description of the parameter group.
An array of VPC subnet IDs. A maximum of 20 subnets can be modified in a single request.
docs.aws.amazon.com/redshift/latest/APIReference/API_ModifyClusterSubnetGroup.html
@param [Hash] options
The unique identifier of the reserved node offering you want to purchase.
The number of reserved nodes you want to purchase. Default: 1
docs.aws.amazon.com/redshift/latest/APIReference/API_PurchaseReservedNodeOffering.html
@param [Hash] options
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. Must be unique for all clusters within an AWS account. Example: myexamplecluster
docs.aws.amazon.com/redshift/latest/APIReference/API_DeleteCluster.html
@param [Hash] options
docs.aws.amazon.com/redshift/latest/APIReference/API_ResetClusterParameterGroup.html
@param [Hash] options
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 AWS account.
The name of the snapshot from which to create the new cluster. This parameter isn't case sensitive. Example: my-snapshot-id
The port number on which the cluster accepts connections. Default: The same port as the original cluster. Constraints: Must be between 1115 and 65535.
The Amazon EC2 Availability Zone in which to restore the cluster. Default: A random, system-chosen Availability Zone. Example: us-east-1a
If true , upgrades can be applied during the maintenance window to the Amazon Redshift engine that is running on the cluster. Default: true
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.
If true , the cluster can be accessed from a public network.
The AWS customer 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.
docs.aws.amazon.com/redshift/latest/APIReference/API_RestoreFromClusterSnapshot.html
@param [Hash] options
The name of the security Group from which to revoke the ingress rule.
The IP range for which to revoke access. This range must be a valid Classless Inter-Domain Routing (CIDR) block of IP addresses. If CIDRIP is specified, EC2SecurityGroupName and EC2SecurityGroupOwnerId cannot be provided.
The name of the EC2 Security Group whose access is to be revoked. If EC2SecurityGroupName is specified, EC2SecurityGroupOwnerId must also be provided and CIDRIP cannot be provided.
The AWS account number of the owner of the security group specified in the EC2SecurityGroupName parameter. The AWS access key ID is not an acceptable value. If EC2SecurityGroupOwnerId is specified, EC2SecurityGroupName must also be provided. and CIDRIP cannot be provided. Example: 111122223333
docs.aws.amazon.com/redshift/latest/APIReference/API_RevokeClusterSecurityGroupIngress.html
@param [Hash] options
The identifier of the snapshot that the account can no longer access.
The identifier of the AWS customer account that can no longer restore the specified snapshot.
docs.aws.amazon.com/redshift/latest/APIReference/API_RevokeSnapshotAccess.html