summary
Help page for setting up Data Mart Configuration with Amazon Web Services' Redshift.
Setting items
STEP1 Basic settings
| item name | indispensable | default value | Contents |
|---|---|---|---|
| Amazon Redshift Connection Configuration | Yes | - | From the pre-registered Amazon Redshift Connection Configuration, select the one that has the necessary permissions for this ETL Configuration. |
| database | Yes | - | Specify the database to which the data will be output. |
| Custom Variable | No | - | Custom Variables set here can be used for query and table names. See About Custom Variables for more information. |
Query settings
| item name | indispensable | default value | Contents |
|---|---|---|---|
| query execution mode | Yes | Data Transfer Mode | You can choose from the following two modes Data transfer mode You can easily perform rewashing and appending to tables by simply specifying SQL and the destination table. Free description mode You are free to execute any query (DDL, DELETE, INSERT, etc.) against the DWH to which you are connected. |
| query | Yes | - | Enter SQL to retrieve transfer data from Amazon Redshift. Custom Variables can also be used to dynamically determine the value of a setting during ETL Configuration of TROCCO's data. Note that the FROM clause should not include the database name, but rather a query in the form "FROM schema_name.table_name". |
In addition, the following ETL Configuration can be specified only when the query execution mode is Data Setting mode.
| Item Name | Required | Default Value | Contents |
|---|---|---|---|
| Destination schema | Yes | - | Specifies the name of the schema to which data will be output. |
| Destination Table | Yes | - | Specify the table name of the data output destination. |
| Yes | - | The following writing methods can be selected. Addendum Wash (execute TRUNCATE before transfer) |
Table column naming constraints
Basically, follow the official AWS documentation - Names and Identifiers.
However, delimited identifiers (identifiers enclosed in double quotes) are not supported. Please understand that we are not responsible for any loss or damage to your property.
Job Setting
| item name | indispensable | default value | Contents |
|---|---|---|---|
| Parallel execution of jobs | ✓ | No parallel job execution. | Select whether or not to run a job if another job with the same Data Mart Configuration is running at the time the job is run. |