AWS Amazon Redshift Parameter Group

This page shows how to write Terraform and CloudFormation for Amazon Redshift Parameter Group and write them securely.

aws_redshift_parameter_group (Terraform)

The Parameter Group in Amazon Redshift can be configured in Terraform with the resource name aws_redshift_parameter_group. The following sections describe 5 examples of how to use the resource and its parameters.

Example Usage from GitHub

aws_redshift_policy_test.tf#L10
resource "aws_redshift_parameter_group" "bar" {
  name = "parameter-group-test-terraform"
  family = "redshift-1.0"
  parameter {
    name = "require_ssl"
    value = "false"
main.tf#L2
resource "aws_redshift_parameter_group" "failasfalse" {
  name   = var.param_group_name
  family = "redshift-1.0"

  parameter {
    name  = "require_ssl"
main.tf#L2
resource "aws_redshift_parameter_group" "failasfalse" {
  name   = var.param_group_name
  family = "redshift-1.0"

  parameter {
    name  = "require_ssl"
aws_all_issues_test.tf#L10
resource "aws_redshift_parameter_group" "bar" {
  name = "parameter-group-test-terraform"
  family = "redshift-1.0"
  parameter {
    name = "require_ssl"
    value = "false"
aws_all_issues_test.tf#L10
resource "aws_redshift_parameter_group" "bar" {
  name = "parameter-group-test-terraform"
  family = "redshift-1.0"
  parameter {
    name = "require_ssl"
    value = "false"

Review your Terraform file for AWS best practices

Shisho Cloud, our free checker to make sure your Terraform configuration follows best practices, is available (beta).

Parameters

Explanation in Terraform Registry

Provides a Redshift Cluster parameter group resource.

AWS::Redshift::ClusterParameterGroup (CloudFormation)

The ClusterParameterGroup in Redshift can be configured in CloudFormation with the resource name AWS::Redshift::ClusterParameterGroup. The following sections describe 10 examples of how to use the resource and its parameters.

Example Usage from GitHub

redshift.yml#L42
    Type: AWS::Redshift::ClusterParameterGroup
      Properties:
        Description: Parameter group for redshift cluster
        ParameterGroupFamily: redshift-1.0
        Parameters:
          - ParameterName: max_concurrency_scaling_cluster
redshift-template.yml#L40
    Type: AWS::Redshift::ClusterParameterGroup
    Properties:
      Description: redshift cluster param group
      ParameterGroupFamily: redshift-1.0
      Parameters:
        - ParameterName: require_ssl
redshift.yml#L27
    Type: AWS::Redshift::ClusterParameterGroup
    Properties:
      Description: Parameter group for redshift cluster
      ParameterGroupFamily: redshift-1.0
      Parameters:
        - ParameterName: max_concurrency_scaling_clusters
redshift.yml#L25
    Type: AWS::Redshift::ClusterParameterGroup
    Properties:
      Description: Parameter group for redshift cluster
      ParameterGroupFamily: redshift-1.0
      Parameters:
        - ParameterName: max_concurrency_scaling_clusters
redshift.yml#L24
    Type: AWS::Redshift::ClusterParameterGroup
    Properties:
      Description: Parameter group for redshift cluster
      ParameterGroupFamily: redshift-1.0
      Parameters:
        - ParameterName: max_concurrency_scaling_clusters
redshift_paramsgroup.json#L4
      "Type" : "AWS::Redshift::ClusterParameterGroup",
      "Properties" : {
        "Description" : "{{settings["description"]}}",
        "ParameterGroupFamily" : "{{settings["groupfamily"]}}",
        "Parameters" : [
        {% for k, v in settings["parameters"].iteritems() %}
AWS_Redshift_RequireSSL.json#L4
            "Type": "AWS::Redshift::ClusterParameterGroup",
            "Properties": {
                "Description": "String",
                "ParameterGroupFamily": "String",
                "Parameters": [{
                    "ParameterName": "require_ssl",
RedshiftClusterParameterGroupSpecification.json#L3
    "AWS::Redshift::ClusterParameterGroup.Parameter": {
      "Documentation": "http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-property-redshift-clusterparametergroup-parameter.html",
      "Properties": {
        "ParameterName": {
          "Documentation": "http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-property-redshift-clusterparametergroup-parameter.html#cfn-redshift-clusterparametergroup-parameter-parametername",
          "PrimitiveType": "String",
RedshiftClusterParameterGroupSpecification.json#L3
    "AWS::Redshift::ClusterParameterGroup.Parameter": {
      "Documentation": "http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-property-redshift-clusterparametergroup-parameter.html",
      "Properties": {
        "ParameterName": {
          "Documentation": "http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-property-redshift-clusterparametergroup-parameter.html#cfn-redshift-clusterparametergroup-parameter-parametername",
          "PrimitiveType": "String",
Redshift.json#L107
  "resourceType" : "AWS::Redshift::ClusterParameterGroup",
  "properties" : [ {
    "propertyName" : "Description",
    "propertyType" : "String",
    "required" : true
  }, {

Parameters

Explanation in CloudFormation Registry

Describes a parameter group.

Frequently asked questions

What is AWS Amazon Redshift Parameter Group?

AWS Amazon Redshift Parameter Group is a resource for Amazon Redshift of Amazon Web Service. Settings can be wrote in Terraform and CloudFormation.

Where can I find the example code for the AWS Amazon Redshift Parameter Group?

For Terraform, the ginguyen/GH_large_Oct21-17_37_51, SnidermanIndustries/checkov-fork and sprathod369/iac-example source code examples are useful. See the Terraform Example section for further details.

For CloudFormation, the giusepper11/bootcamp-DE-AWS, benforleo/etl-infrastructure and andresionek91/bootcamp_eng_dados_turma2 source code examples are useful. See the CloudFormation Example section for further details.