/AWS1/CL_TSQTIMESTREAMCONF¶
Configuration to write data into Timestream database and table. This configuration allows the user to map the query result select columns into the destination table columns.
CONSTRUCTOR¶
IMPORTING¶
Required arguments:¶
iv_databasename TYPE /AWS1/TSQRESOURCENAME /AWS1/TSQRESOURCENAME¶
Name of Timestream database to which the query result will be written.
iv_tablename TYPE /AWS1/TSQRESOURCENAME /AWS1/TSQRESOURCENAME¶
Name of Timestream table that the query result will be written to. The table should be within the same database that is provided in Timestream configuration.
iv_timecolumn TYPE /AWS1/TSQSCHEMANAME /AWS1/TSQSCHEMANAME¶
Column from query result that should be used as the time column in destination table. Column type for this should be TIMESTAMP.
it_dimensionmappings TYPE /AWS1/CL_TSQDIMENSIONMAPPING=>TT_DIMENSIONMAPPINGLIST TT_DIMENSIONMAPPINGLIST¶
This is to allow mapping column(s) from the query result to the dimension in the destination table.
Optional arguments:¶
io_multimeasuremappings TYPE REF TO /AWS1/CL_TSQMULTIMEASUREMAPS /AWS1/CL_TSQMULTIMEASUREMAPS¶
Multi-measure mappings.
it_mixedmeasuremappings TYPE /AWS1/CL_TSQMIXEDMEASUREMAP=>TT_MIXEDMEASUREMAPPINGLIST TT_MIXEDMEASUREMAPPINGLIST¶
Specifies how to map measures to multi-measure records.
iv_measurenamecolumn TYPE /AWS1/TSQSCHEMANAME /AWS1/TSQSCHEMANAME¶
Name of the measure column.
Queryable Attributes¶
DatabaseName¶
Name of Timestream database to which the query result will be written.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_DATABASENAME() |
Getter for DATABASENAME, with configurable default |
ASK_DATABASENAME() |
Getter for DATABASENAME w/ exceptions if field has no value |
HAS_DATABASENAME() |
Determine if DATABASENAME has a value |
TableName¶
Name of Timestream table that the query result will be written to. The table should be within the same database that is provided in Timestream configuration.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_TABLENAME() |
Getter for TABLENAME, with configurable default |
ASK_TABLENAME() |
Getter for TABLENAME w/ exceptions if field has no value |
HAS_TABLENAME() |
Determine if TABLENAME has a value |
TimeColumn¶
Column from query result that should be used as the time column in destination table. Column type for this should be TIMESTAMP.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_TIMECOLUMN() |
Getter for TIMECOLUMN, with configurable default |
ASK_TIMECOLUMN() |
Getter for TIMECOLUMN w/ exceptions if field has no value |
HAS_TIMECOLUMN() |
Determine if TIMECOLUMN has a value |
DimensionMappings¶
This is to allow mapping column(s) from the query result to the dimension in the destination table.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_DIMENSIONMAPPINGS() |
Getter for DIMENSIONMAPPINGS, with configurable default |
ASK_DIMENSIONMAPPINGS() |
Getter for DIMENSIONMAPPINGS w/ exceptions if field has no v |
HAS_DIMENSIONMAPPINGS() |
Determine if DIMENSIONMAPPINGS has a value |
MultiMeasureMappings¶
Multi-measure mappings.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_MULTIMEASUREMAPPINGS() |
Getter for MULTIMEASUREMAPPINGS |
MixedMeasureMappings¶
Specifies how to map measures to multi-measure records.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_MIXEDMEASUREMAPPINGS() |
Getter for MIXEDMEASUREMAPPINGS, with configurable default |
ASK_MIXEDMEASUREMAPPINGS() |
Getter for MIXEDMEASUREMAPPINGS w/ exceptions if field has n |
HAS_MIXEDMEASUREMAPPINGS() |
Determine if MIXEDMEASUREMAPPINGS has a value |
MeasureNameColumn¶
Name of the measure column.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_MEASURENAMECOLUMN() |
Getter for MEASURENAMECOLUMN, with configurable default |
ASK_MEASURENAMECOLUMN() |
Getter for MEASURENAMECOLUMN w/ exceptions if field has no v |
HAS_MEASURENAMECOLUMN() |
Determine if MEASURENAMECOLUMN has a value |