Datamart - Redshift
  • 07 Dec 2022
  • 1 Minute to read
  • Dark

Datamart - Redshift

  • Dark

Article Summary


This is a machine-translated version of the original Japanese article.
Please understand that some of the information contained on this page may be inaccurate.


This page is a help page for configuring data mart definitions using Redshift in Amazon Web Services.

Setting items

STEP1 Basic settings

Redshift connection informationYes-Select Redshift connection information.
databaseYes-Specifies the database to which the data is output.
Custom variablesNo-Custom variables set here can be used for queries and table names.
For more information, refer to About Custom Variables.

Query settings

Query Execution ModeYesData Transfer ModeYou can choose from the following two modes.
・Data transfer mode
By simply specifying the SQL and the output destination table, you can easily change and append to the table.
・Free description mode
You can freely execute arbitrary queries (DDL, DELETE, INSERT, etc.) against the connected DWH.
queryYes-Enter SQL to retrieve the transfer data from Redshift.
Custom variables can also be used to dynamically determine the setting value during trocco data transfer.
Do not include the database name in the FROM clause, and write the query in the format "FROM schema_name.table_name".

In addition, the following settings can only be specified when the query execution mode is data transfer mode.

schemaYes-Specifies the schema name to which the data is output.
The dataset name must consist only of letters, numbers, and underscores. (Reference)
tableYes-Specifies the name of the table to which the data is output.
The table name must consist only of letters, numbers, and underscores. (Reference)
Write settings for the destination tableYes-You can choose the following writing methods:
・ Wash (execute TRUNCATE before transfer)

Was this article helpful?