AWS::Timestream::ScheduledQuery TimestreamConfiguration

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.

Syntax

To declare this entity in your AWS CloudFormation template, use the following syntax:

JSON

{
  "DatabaseName" : String,
  "DimensionMappings" : [ DimensionMapping, ... ],
  "MeasureNameColumn" : String,
  "MixedMeasureMappings" : [ MixedMeasureMapping, ... ],
  "MultiMeasureMappings" : MultiMeasureMappings,
  "TableName" : String,
  "TimeColumn" : String
}

YAML

  DatabaseName: String
  DimensionMappings: 
    - DimensionMapping
  MeasureNameColumn: String
  MixedMeasureMappings: 
    - MixedMeasureMapping
  MultiMeasureMappings: 
    MultiMeasureMappings
  TableName: String
  TimeColumn: String

Properties

DatabaseName

Name of Timestream database to which the query result will be written.

Required: Yes

Type: String

Update requires: Replacement

DimensionMappings

This is to allow mapping column(s) from the query result to the dimension in the destination table.

Required: Yes

Type: Array of DimensionMapping

Update requires: Replacement

MeasureNameColumn

Name of the measure column. Also see MultiMeasureMappings and MixedMeasureMappings for how measure name properties on those relate to MeasureNameColumn.

Required: No

Type: String

Update requires: Replacement

MixedMeasureMappings

Specifies how to map measures to multi-measure records.

Required: No

Type: Array of MixedMeasureMapping

Minimum: 1

Update requires: Replacement

MultiMeasureMappings

Multi-measure mappings.

Required: No

Type: MultiMeasureMappings

Update requires: Replacement

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.

Required: Yes

Type: String

Update requires: Replacement

TimeColumn

Column from query result that should be used as the time column in destination table. Column type for this should be TIMESTAMP.

Required: Yes

Type: String

Update requires: Replacement