Amazon Timestream for LiveAnalytics

RootAssetName

null

String

This will be the name for the root asset of the Asset Tree that is created after indexing your table. If it is set to null it will be set to the name of the Datasource Connection.

GenerateTableAsset

true

Boolean

unused

Tables

An empty Table Definition

A List of TimeStreamTables

The collection of table configurations which provide the necessary information to create signals in Seeq.

AccessKeyId

null

String

The IAM Access Key ID for the account that has read access to Timestream.

SecretAccessKey

null

String/SecretFile

The IAM Access Key Secret for the account that has read access to Timestream.

Region

us-east-1

String

The AWS region that your Timestream database is hosted in.

Id

<Enter ID>

String

This is the unique ID for the table configuration itself. Note that changing the Id field will cause the relevant signals to be indexed under a different dataId in Seeq. You can use a GUID generator like https://guidgenerator.com/ to create a new one for each definition.

Name

null

String

This is the name of the Timestream table.

At least Name or NameQuery must be defined within each SignalTableDefinition. It is possible to provide Name and NameQuery parameters at the same time. Duplicate table names are ignored.

NameQuery

null

String

This is a query that defines how to obtain a list of tables with identical schemas. This property can hold a query like SHOW TABLES FROM connectordb LIKE 'dataset%' which will pull all tables from the database called connectordb that start wtih dataset.

At least Name or NameQuery must be defined within each SignalTableDefinition. It is possible to provide Name and NameQuery parameters at the same time. Duplicate table names are ignored.

GroupBy

Empty list

A list of Strings

This is a list of columns that can be used to group signals into an asset hierarchy based on distinct column value combinations. The column name order is important - it is used to generate the asset hierarchy. Example: "GroupBy" : [ "country", "region_name", "province_name" ] parameter definition produces the following hierarchy: <country>\<region_name>\<province_name>. When GroupBy is provided - the associated signal collection is linked to the asset defined by the GroupBy leaf element. When GroupBy parameter is not provided, the signal collection is linked to the asset representing BigQuery table.

GroupByLimit

0

Integer

A limit on the number of results (asset paths) that can be returned from the GroupBy. A GroupByLimit of 0 indicates no limit.

DataColumns

[]

A list of Strings

The list of columns that contain data that should be synced to Seeq as signal values . Each listed column name creates a unique Seeq signal. By default, signal name is equal to data column name. For example: "DataColumns" : [ "average_temperature_celsius" ].

At least DataColumns or DataColumnQuery parameter must be defined within each table configuration. It is possible to provide DataColumns and DataColumnQuery parameters at the same time. Duplicate column names are ignored.

DataColumnQuery

null

String

User provided query which allows to obtain the list of columns within the same table which data fields used as Seeq signal’s values. DataColumnQuery can contain the placeholders %projectid%, %dataset% and %tablename%, which will be replaced with actual values when querying the source system. For example: "DataColumnQuery" : "SHOW MEASURES FROM %database%.%tablename% LIKE 'data%'"

At least DataColumns or DataColumnQuery parameter must be defined within each table configuration. It is possible to provide DataColumns and DataColumnQuery parameters at the same time. Duplicate column names are ignored.