Amazon Redshift Podręcznik Użytkownika Pobierz pdf (Strona 83)

Associating a Parameter Group with a Cluster

Each cluster you provision has one parameter group associated with it.You can associate a parameter

group with a cluster when you create the cluster, or you can associate a parameter group later by modifying

the cluster. For more information, see To create a cluster (p. 14) and To modify a cluster (p. 21).

Managing Parameter Groups Using the AWS

SDK for Java

This example demonstrates the following tasks related to parameter groups:

• Creating a parameter group

• Modifying a parameter group

• Associating a parameter group with a cluster

• Getting information about parameter groups

This example creates a new parameter group, parametergroup1, and makes the following updates:

• Changes the parameter extra_float_digits to 2 from the default value of 0.

• Replaces the existing workload management configuration (wlm_json_configuration parameter)

with the following JSON which defines a queue in addition to the default queue.

[

{

"user_group":[

"example_user_group1"

"query_group":[

"example_query_group1"

"query_concurrency":7

{

"query_concurrency":5

}

]

The preceding JSON is an array of two objects, one for each queue.The first object defines a queue with

specific user group and query group. It also sets the concurrency level to 7.

{

"user_group":[

"example_user_group1"

"query_group":[

"example_query_group1"

"query_concurrency":7

}

API Version 2012-12-01

Amazon Redshift Management Guide

Associating a Parameter Group with a Cluster

1 2 ... 78 79 80 81 82 83 84 85 86 87 88 ... 254 255

Brak uwag

Amazon Redshift Podręcznik Użytkownika Strona 83