Configure Redshift Permission Setup

Last updated on October 23, 2024

Overview

For the Redshift Connector to effectively write data to your Amazon Redshift database, you need to set up appropriate permissions for the Redshift user.

This section outlines the steps to create a Redshift database, create a user, and grant the necessary privileges for writing data.

Create Redshift database and user

1. Create a Redshift database on your AWS account using the command:

   CREATE DATABASE <database_name>;

2. Create a Redshift user using the command:

   CREATE USER <user_name> WITH password <user_password> | DISABLE;
   注記

   The password is optional as it's not needed for the connection.

Grant Redshift user privileges

1. Once the Redshift user is created, you need to grant appropriate privileges to allow the Connector to write data to the database.

2. Grant the CREATE privilege on the database to the Redshift user:

   GRANT CREATE ON DATABASE <database_name> TO <user_name>;

3. Ensure that the Redshift user has sufficient privileges to perform the necessary actions for data ingestion and management.