Editing Replication Task for Amazon Redshift

Replication task editor for data replication to Amazon Redshift is different from the replication task editor for other sources, and it allows you to specify additional parameters, specific for Amazon Redshift. These parameters affect the Redshift table creation. The editor consists of the three tabs:

Table

This tab allows specifying settings for the whole table.

Distribution Style

Determines how Amazon Redshift will distribute the rows loaded to the table between the node slices. It can have the following values:

  • Auto — this parameter when creating a table. Default value is used.
  • Even — The rows will be evenly distributed between the node slices in a round-robin fashion, regardless of the row data values.
  • Key — The rows will be distributed between the node slices depending on the values in one of the columns.
  • ALL — Every node will have its own copy of all the table rows.

You can find more information about distribution styles in the Amazon Redshift documentation.

Distribution Key

Determines the column, based on values of which the rows will be distributed between the node slices. If Auto is selected, this parameter will be omitted when creating the table.

Distribution Sort Keys

Specifies the column list, which will be used for sorting table data when performing initial data loading to the table.

Columns

This tab allows you to configure settings for the Redshift table columns. It also allows you to exclude some of the columns from replication.

Clear check boxes for the columns you want to exclude from replication.

You can also edit column length for textual columns and precision and scale - for numeric columns. Additionally you can select Compression Encoding for each column. Auto means that compression encoding won’t be specified in the CREATE TABLE statement. See Amazon Redshift documentation for more information about compression encodings.

Filters

This tab allows you to configure filtering settings.