Data Mart - Amazon Redshift
  • 17 Jul 2024
  • PDF

Data Mart - Amazon Redshift

  • PDF

Article summary


Help page for setting up data mart definitions using Amazon Web Services' Redshift.

Setting items

STEP1 Basic settings

item nameindispensabledefault valueContents
Amazon Redshift connection informationYes-Select from the pre-registered Amazon Redshift connection information that has the necessary permissions for this transfer setup.
databaseYes-Specify the database to which the data will be output.
custom variableNo-Custom variables set here can be used for query and table names.
See About Custom Variables for more information.

Query settings

item nameindispensabledefault valueContents
query execution modeYesData Transfer ModeYou 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.
queryYes-Enter SQL to retrieve transfer data from Amazon Redshift.
Custom variables can be used to dynamically determine set values during TROCCO data transfer.
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 settings can be specified only when the query execution mode is data transfer mode.

Item NameRequiredDefault ValueContents
Destination schemaYes-Specifies the name of the schema to which data will be output.
Destination TableYes-Specify the table name of the data output destination.
Yes-The following writing methods can be selected.
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 startup settings

item nameindispensabledefault valueContents
Parallel execution of jobsNo parallel job execution.Select whether or not to run a job if another job with the same data mart definition is running at the time the job is run.
  • No parallel job execution: jobs are not executed and skipped.
  • Allow jobs to run in parallel: Jobs will run.

  • Was this article helpful?