/AWS1/CL_GLUUPSERTREDTGTOPTS¶
The options to configure an upsert operation when writing to a Redshift target .
CONSTRUCTOR¶
IMPORTING¶
Optional arguments:¶
iv_tablelocation TYPE /AWS1/GLUENCLOSEDINSTRINGPRP /AWS1/GLUENCLOSEDINSTRINGPRP¶
The physical location of the Redshift table.
iv_connectionname TYPE /AWS1/GLUENCLOSEDINSTRINGPRP /AWS1/GLUENCLOSEDINSTRINGPRP¶
The name of the connection to use to write to Redshift.
it_upsertkeys TYPE /AWS1/CL_GLUENCLOSEDINSTRPRP01=>TT_ENCLOSEDINSTRINGPRPSMINONE TT_ENCLOSEDINSTRINGPRPSMINONE¶
The keys used to determine whether to perform an update or insert.
Queryable Attributes¶
TableLocation¶
The physical location of the Redshift table.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_TABLELOCATION() |
Getter for TABLELOCATION, with configurable default |
ASK_TABLELOCATION() |
Getter for TABLELOCATION w/ exceptions if field has no value |
HAS_TABLELOCATION() |
Determine if TABLELOCATION has a value |
ConnectionName¶
The name of the connection to use to write to Redshift.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_CONNECTIONNAME() |
Getter for CONNECTIONNAME, with configurable default |
ASK_CONNECTIONNAME() |
Getter for CONNECTIONNAME w/ exceptions if field has no valu |
HAS_CONNECTIONNAME() |
Determine if CONNECTIONNAME has a value |
UpsertKeys¶
The keys used to determine whether to perform an update or insert.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_UPSERTKEYS() |
Getter for UPSERTKEYS, with configurable default |
ASK_UPSERTKEYS() |
Getter for UPSERTKEYS w/ exceptions if field has no value |
HAS_UPSERTKEYS() |
Determine if UPSERTKEYS has a value |