You must enter the following credentials when configuring this source:
| Key | Description | Sample value |
|---|---|---|
database |
The name of the database you want to load data from. | demo |
host |
The host name of your database. | mage-prod.3.us-west-2.redshift.amazonaws.com |
password |
Password for the user to access the database. | abc123... |
port |
Port of the running database (typically 5439). | 5439 |
region |
Region of your database. | us-west-2 |
schema |
Schema of the data you want to load data from. | public |
table |
Name of the table that will be created to store data from your source. | dim_users_v1 |
user |
Name of the user that will access the database (must have permissions to read and write to specified schema). | awsuser |
Alternatively, instead of using password and user, you can use the following credentials to authenticate:
| Key | Description | Sample value |
|---|---|---|
access_key_id |
The access key for the IAM role or IAM user configured for IAM database authentication. | abc123... |
cluster_identifier |
The cluster identifier of the Amazon Redshift Cluster. | mage-prod |
db_user |
The user ID to use with Amazon Redshift. | admin |
secret_access_key |
The secret access key for the IAM role or IAM user configured for IAM database authentication. | xyz123 |
| Key | Description | Sample value |
|---|---|---|
skip_schema_creation |
If true, Mage won't run CREATE SCHEMA command. For more information, see this issue |
true |
lower_case |
If true, Mage will set all columns name as lower case. Default is true |
true |
Use GRANT command to grant the user permissions to create schema and insert data into tables:
GRANT CREATE ON DATABASE "database" TO user;
GRANT CREATE ON ALL TABLES IN SCHEMA "schema" TO user;