Create and configure a target Amazon Redshift data warehouse
In this step, you create and configure a target Amazon Redshift data warehouse, such as a Redshift Serverless workgroup or a provisioned cluster. If you already have a Amazon Redshift data warehouse configured for use with zero-ETL integrations, you can skip this step.
Your target data warehouse must have the following characteristics:
-
Running Amazon Redshift Serverless or a provisioned cluster of an RA3 node type.
-
Has case sensitivity (
enable_case_sensitive_identifier) turned on. For more information, see Turn on case sensitivity for your data warehouse. -
Encrypted, if your target data warehouse is an Amazon Redshift provisioned cluster. For more information, see Amazon Redshift database encryption.
-
Created in the same Amazon Region as the integration source.
To create your target data warehouse for your zero-ETL integrations, see one of the following topics depending on your deployment type:
-
To create an Amazon Redshift provisioned cluster, see Creating a cluster.
-
To create an Amazon Redshift Serverless workgroup with a namespace, see Creating a workgroup with a namespace.
When you create a provisioned cluster, Amazon Redshift also creates a default parameter group. You can't edit the default parameter group. However, you can create a custom parameter group before creating a new cluster and then associate it with the cluster. Or, you can edit the parameter group that will be associated with the created cluster. You must also turn on case sensitivity for the parameter group either when creating the custom parameter group or when editing a current one to use zero-ETL integrations.
To create a custom parameter group using the Amazon Redshift console or the Amazon CLI, see Creating a parameter group.