cluster_versions

Creates, updates, deletes, gets or lists a cluster_versions resource.

Overview

Name	cluster_versions
Type	Resource
Id	aws.redshift.cluster_versions

Fields

The following fields are returned by SELECT queries:

describe_cluster_versions

Name	Datatype	Description
cluster_parameter_group_family	string	The name of the cluster parameter group family for the cluster.
cluster_version	string	The version number used by the cluster.
description	string	The description of the cluster version.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
describe_cluster_versions	select	region	ClusterVersion, ClusterParameterGroupFamily, MaxRecords, Marker	Returns descriptions of the available Amazon Redshift cluster versions. You can call this operation even before creating any clusters to learn more about the Amazon Redshift versions. For more information about managing clusters, go to Amazon Redshift Clusters in the Amazon Redshift Cluster Management Guide.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
region	string	AWS region (default: us-east-1)
ClusterParameterGroupFamily	string	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 Cannot end with a hyphen or contain two consecutive hyphens
ClusterVersion	string	The specific cluster version to return. Example: 1.0
Marker	string	An optional parameter that specifies the starting point to return a set of response records. When the results of a DescribeClusterVersions request exceed the value specified in MaxRecords, Amazon Web Services returns a value in the Marker field of the response. You can retrieve the next set of response records by providing the returned marker value in the Marker parameter and retrying the request.
MaxRecords	integer	The maximum number of response records to return in each call. If the number of remaining response records exceeds the specified MaxRecords value, a value is returned in a marker field of the response. You can retrieve the next set of records by retrying the command with the returned marker value. Default: 100 Constraints: minimum 20, maximum 100.

SELECT examples

describe_cluster_versions

Returns descriptions of the available Amazon Redshift cluster versions. You can call this operation even before creating any clusters to learn more about the Amazon Redshift versions. For more information about managing clusters, go to Amazon Redshift Clusters in the Amazon Redshift Cluster Management Guide.

SELECT
cluster_parameter_group_family,
cluster_version,
description
FROM aws.redshift.cluster_versions
WHERE region = '{{ region }}' -- required
AND ClusterVersion = '{{ ClusterVersion }}'
AND ClusterParameterGroupFamily = '{{ ClusterParameterGroupFamily }}'
AND MaxRecords = '{{ MaxRecords }}'
AND Marker = '{{ Marker }}'
;