Skip to content

/AWS1/CL_GLUREDSHIFTTARGET

Specifies a target that uses Amazon Redshift.

CONSTRUCTOR

IMPORTING

Required arguments:

iv_name TYPE /AWS1/GLUNODENAME /AWS1/GLUNODENAME

The name of the data target.

it_inputs TYPE /AWS1/CL_GLUONEINPUT_W=>TT_ONEINPUT TT_ONEINPUT

The nodes that are inputs to the data target.

iv_database TYPE /AWS1/GLUENCLOSEDINSTRINGPRP /AWS1/GLUENCLOSEDINSTRINGPRP

The name of the database to write to.

iv_table TYPE /AWS1/GLUENCLOSEDINSTRINGPRP /AWS1/GLUENCLOSEDINSTRINGPRP

The name of the table in the database to write to.

Optional arguments:

iv_redshifttmpdir TYPE /AWS1/GLUENCLOSEDINSTRINGPRP /AWS1/GLUENCLOSEDINSTRINGPRP

The Amazon S3 path where temporary data can be staged when copying out of the database.

iv_tmpdiriamrole TYPE /AWS1/GLUENCLOSEDINSTRINGPRP /AWS1/GLUENCLOSEDINSTRINGPRP

The IAM role with permissions.

io_upsertredshiftoptions TYPE REF TO /AWS1/CL_GLUUPSERTREDTGTOPTS /AWS1/CL_GLUUPSERTREDTGTOPTS

The set of options to configure an upsert operation when writing to a Redshift target.


Queryable Attributes

Name

The name of the data target.

Accessible with the following methods

Method Description
GET_NAME() Getter for NAME, with configurable default
ASK_NAME() Getter for NAME w/ exceptions if field has no value
HAS_NAME() Determine if NAME has a value

Inputs

The nodes that are inputs to the data target.

Accessible with the following methods

Method Description
GET_INPUTS() Getter for INPUTS, with configurable default
ASK_INPUTS() Getter for INPUTS w/ exceptions if field has no value
HAS_INPUTS() Determine if INPUTS has a value

Database

The name of the database to write to.

Accessible with the following methods

Method Description
GET_DATABASE() Getter for DATABASE, with configurable default
ASK_DATABASE() Getter for DATABASE w/ exceptions if field has no value
HAS_DATABASE() Determine if DATABASE has a value

Table

The name of the table in the database to write to.

Accessible with the following methods

Method Description
GET_TABLE() Getter for TABLE, with configurable default
ASK_TABLE() Getter for TABLE w/ exceptions if field has no value
HAS_TABLE() Determine if TABLE has a value

RedshiftTmpDir

The Amazon S3 path where temporary data can be staged when copying out of the database.

Accessible with the following methods

Method Description
GET_REDSHIFTTMPDIR() Getter for REDSHIFTTMPDIR, with configurable default
ASK_REDSHIFTTMPDIR() Getter for REDSHIFTTMPDIR w/ exceptions if field has no valu
HAS_REDSHIFTTMPDIR() Determine if REDSHIFTTMPDIR has a value

TmpDirIAMRole

The IAM role with permissions.

Accessible with the following methods

Method Description
GET_TMPDIRIAMROLE() Getter for TMPDIRIAMROLE, with configurable default
ASK_TMPDIRIAMROLE() Getter for TMPDIRIAMROLE w/ exceptions if field has no value
HAS_TMPDIRIAMROLE() Determine if TMPDIRIAMROLE has a value

UpsertRedshiftOptions

The set of options to configure an upsert operation when writing to a Redshift target.

Accessible with the following methods

Method Description
GET_UPSERTREDSHIFTOPTIONS() Getter for UPSERTREDSHIFTOPTIONS