Top / Amazon Web Service / AWS Amazon Redshift / Parameter Group

AWS Amazon Redshift Parameter Group

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

terraform-logo

Review your .tf file for AWS best practices

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

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

>> from Terraform Registry

Explanation in Terraform Registry

Provides a Redshift Cluster parameter group resource.

>> from Terraform Registry

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

>> from AWS CloudFormation Documentation

Explanation in CloudFormation Registry

Describes a parameter group.

>> from AWS CloudFormation Documentation

The Other Related AWS Amazon Redshift Resources

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.

security-icon

Automate config file reviews on your commits

Fix issues in your infrastructure as code with auto-generated patches.

Table of Contents