Timestream also allows you to ingest the data with one measure per time series record. Below are the schema details when ingested using single measure records.
Table Schema
Below is the table schema once the data is ingested using multi-measure records. It is the output of DESCRIBE query. Assuming the data is ingested into a database raw_data and table devops, below is the query:
DESCRIBE "raw_data"."devops_single"
Column Type Timestream attribute type
availability_zone varchar DIMENSION
microservice_name varchar DIMENSION
Column Type Timestream attribute type
instance_name varchar DIMENSION
process_name varchar DIMENSION
os_version varchar DIMENSION
jdk_version varchar DIMENSION
cell varchar DIMENSION
region varchar DIMENSION
silo varchar DIMENSION
instance_type varchar DIMENSION
measure_name varchar MEASURE_NAME
time timestamp TIMESTAMP
measure_value::double double MEASURE_VALUE
measure_value::bigint bigint MEASURE_VALUE
measure_value::varchar varchar MEASURE_VALUE
Measure Schema
Below is the measure schema returned by the SHOW MEASURES query.
SHOW MEASURES FROM "raw_data"."devops_single"
measure_name data_type dimensions
cpu_hi double [{'dimension_name':
'availability_zone', 'data_type':
'varchar'}, {'dimension_name':
'microservice_name', 'data_type':
'varchar'}, {'dimension_name':
'instance_name', 'data_type':
'varchar'}, {'dimension_name':
'os_version', 'data_type':
'varchar'}, {'dimension_name':
'cell', 'data_type': 'varchar'}, {'dimension_name': 'region', 'data_type': 'varchar'}, {'dimension_name': 'silo', 'data_type': 'varchar'}, {'dimension_name':
'instance_type', 'data_type':
'varchar'}]
cpu_idle double [{'dimension_name':
'availability_zone', 'data_type':
'varchar'}, {'dimension_name':
'microservice_name', 'data_type':
measure_name data_type dimensions
'varchar'}, {'dimension_name':
'instance_name', 'data_type':
'varchar'}, {'dimension_name':
'os_version', 'data_type':
'varchar'}, {'dimension_name':
'cell', 'data_type': 'varchar'}, {'dimension_name': 'region', 'data_type': 'varchar'}, {'dimension_name': 'silo', 'data_type': 'varchar'}, {'dimension_name':
'instance_type', 'data_type':
'varchar'}]
cpu_iowait double [{'dimension_name':
'availability_zone', 'data_type':
'varchar'}, {'dimension_name':
'microservice_name', 'data_type':
'varchar'}, {'dimension_name':
'instance_name', 'data_type':
'varchar'}, {'dimension_name':
'os_version', 'data_type':
'varchar'}, {'dimension_name':
'cell', 'data_type': 'varchar'}, {'dimension_name': 'region', 'data_type': 'varchar'}, {'dimension_name': 'silo', 'data_type': 'varchar'}, {'dimension_name':
'instance_type', 'data_type':
'varchar'}]
cpu_nice double [{'dimension_name':
'availability_zone', 'data_type':
'varchar'}, {'dimension_name':
'microservice_name', 'data_type':
'varchar'}, {'dimension_name':
'instance_name', 'data_type':
'varchar'}, {'dimension_name':
'os_version', 'data_type':
'varchar'}, {'dimension_name':
'cell', 'data_type': 'varchar'}, {'dimension_name': 'region', 'data_type': 'varchar'}, {'dimension_name': 'silo', 'data_type': 'varchar'}, {'dimension_name':
'instance_type', 'data_type':
'varchar'}]
measure_name data_type dimensions
cpu_si double [{'dimension_name':
'availability_zone', 'data_type':
'varchar'}, {'dimension_name':
'microservice_name', 'data_type':
'varchar'}, {'dimension_name':
'instance_name', 'data_type':
'varchar'}, {'dimension_name':
'os_version', 'data_type':
'varchar'}, {'dimension_name':
'cell', 'data_type': 'varchar'}, {'dimension_name': 'region', 'data_type': 'varchar'}, {'dimension_name': 'silo', 'data_type': 'varchar'}, {'dimension_name':
'instance_type', 'data_type':
'varchar'}]
cpu_steal double [{'dimension_name':
'availability_zone', 'data_type':
'varchar'}, {'dimension_name':
'microservice_name', 'data_type':
'varchar'}, {'dimension_name':
'instance_name', 'data_type':
'varchar'}, {'dimension_name':
'os_version', 'data_type':
'varchar'}, {'dimension_name':
'cell', 'data_type': 'varchar'}, {'dimension_name': 'region', 'data_type': 'varchar'}, {'dimension_name': 'silo', 'data_type': 'varchar'}, {'dimension_name':
'instance_type', 'data_type':
'varchar'}]
cpu_system double [{'dimension_name':
'availability_zone', 'data_type':
'varchar'}, {'dimension_name':
'microservice_name', 'data_type':
'varchar'}, {'dimension_name':
'instance_name', 'data_type':
'varchar'}, {'dimension_name':
'os_version', 'data_type':
'varchar'}, {'dimension_name':
'cell', 'data_type': 'varchar'}, {'dimension_name': 'region', 'data_type': 'varchar'}, {'dimension_name': 'silo', 'data_type': 'varchar'}, {'dimension_name':
'instance_type', 'data_type':
'varchar'}]
measure_name data_type dimensions
cpu_user double [{'dimension_name':
'availability_zone', 'data_type':
'varchar'}, {'dimension_name':
'microservice_name', 'data_type':
'varchar'}, {'dimension_name':
'instance_name', 'data_type':
'varchar'}, {'dimension_name':
'os_version', 'data_type':
'varchar'}, {'dimension_name':
'cell', 'data_type': 'varchar'}, {'dimension_name': 'region', 'data_type': 'varchar'}, {'dimension_name': 'silo', 'data_type': 'varchar'}, {'dimension_name':
'instance_type', 'data_type':
'varchar'}]
disk_free double [{'dimension_name':
'availability_zone', 'data_type':
'varchar'}, {'dimension_name':
'microservice_name', 'data_type':
'varchar'}, {'dimension_name':
'instance_name', 'data_type':
'varchar'}, {'dimension_name':
'os_version', 'data_type':
'varchar'}, {'dimension_name':
'cell', 'data_type': 'varchar'}, {'dimension_name': 'region', 'data_type': 'varchar'}, {'dimension_name': 'silo', 'data_type': 'varchar'}, {'dimension_name':
'instance_type', 'data_type':
'varchar'}]
disk_io_reads double [{'dimension_name':
'availability_zone', 'data_type':
'varchar'}, {'dimension_name':
'microservice_name', 'data_type':
'varchar'}, {'dimension_name':
'instance_name', 'data_type':
'varchar'}, {'dimension_name':
'os_version', 'data_type':
'varchar'}, {'dimension_name':
'cell', 'data_type': 'varchar'}, {'dimension_name': 'region', 'data_type': 'varchar'}, {'dimension_name': 'silo', 'data_type': 'varchar'}, {'dimension_name':
'instance_type', 'data_type':
'varchar'}]
measure_name data_type dimensions
disk_io_writes double [{'dimension_name':
'availability_zone', 'data_type':
'varchar'}, {'dimension_name':
'microservice_name', 'data_type':
'varchar'}, {'dimension_name':
'instance_name', 'data_type':
'varchar'}, {'dimension_name':
'os_version', 'data_type':
'varchar'}, {'dimension_name':
'cell', 'data_type': 'varchar'}, {'dimension_name': 'region', 'data_type': 'varchar'}, {'dimension_name': 'silo', 'data_type': 'varchar'}, {'dimension_name':
'instance_type', 'data_type':
'varchar'}]
disk_used double [{'dimension_name':
'availability_zone', 'data_type':
'varchar'}, {'dimension_name':
'microservice_name', 'data_type':
'varchar'}, {'dimension_name':
'instance_name', 'data_type':
'varchar'}, {'dimension_name':
'os_version', 'data_type':
'varchar'}, {'dimension_name':
'cell', 'data_type': 'varchar'}, {'dimension_name': 'region', 'data_type': 'varchar'}, {'dimension_name': 'silo', 'data_type': 'varchar'}, {'dimension_name':
'instance_type', 'data_type':
'varchar'}]
file_descriptors_in_use double [{'dimension_name':
'availability_zone', 'data_type':
'varchar'}, {'dimension_name':
'microservice_name', 'data_type':
'varchar'}, {'dimension_name':
'instance_name', 'data_type':
'varchar'}, {'dimension_name':
'os_version', 'data_type':
'varchar'}, {'dimension_name':
'cell', 'data_type': 'varchar'}, {'dimension_name': 'region', 'data_type': 'varchar'}, {'dimension_name': 'silo', 'data_type': 'varchar'}, {'dimension_name':
'instance_type', 'data_type':
'varchar'}]
measure_name data_type dimensions
gc_pause double [{'dimension_name':
'availability_zone', 'data_type':
'varchar'}, {'dimension_name':
'microservice_name', 'data_type':
'varchar'}, {'dimension_name':
'instance_name', 'data_type':
'varchar'}, {'dimension_name':
'process_name', 'data_type':
'varchar'}, {'dimension_name':
'jdk_version', 'data_type':
'varchar'}, {'dimension_name':
'cell', 'data_type': 'varchar'}, {'dimension_name': 'region', 'data_type': 'varchar'}, {'dimension_name': 'silo', 'data_type': 'varchar'}]
gc_reclaimed double [{'dimension_name':
'availability_zone', 'data_type':
'varchar'}, {'dimension_name':
'microservice_name', 'data_type':
'varchar'}, {'dimension_name':
'instance_name', 'data_type':
'varchar'}, {'dimension_name':
'process_name', 'data_type':
'varchar'}, {'dimension_name':
'jdk_version', 'data_type':
'varchar'}, {'dimension_name':
'cell', 'data_type': 'varchar'}, {'dimension_name': 'region', 'data_type': 'varchar'}, {'dimension_name': 'silo', 'data_type': 'varchar'}]
latency_per_read double [{'dimension_name':
'availability_zone', 'data_type':
'varchar'}, {'dimension_name':
'microservice_name', 'data_type':
'varchar'}, {'dimension_name':
'instance_name', 'data_type':
'varchar'}, {'dimension_name':
'os_version', 'data_type':
'varchar'}, {'dimension_name':
'cell', 'data_type': 'varchar'}, {'dimension_name': 'region', 'data_type': 'varchar'}, {'dimension_name': 'silo', 'data_type': 'varchar'}, {'dimension_name':
'instance_type', 'data_type':
'varchar'}]
measure_name data_type dimensions
latency_per_write double [{'dimension_name':
'availability_zone', 'data_type':
'varchar'}, {'dimension_name':
'microservice_name', 'data_type':
'varchar'}, {'dimension_name':
'instance_name', 'data_type':
'varchar'}, {'dimension_name':
'os_version', 'data_type':
'varchar'}, {'dimension_name':
'cell', 'data_type': 'varchar'}, {'dimension_name': 'region', 'data_type': 'varchar'}, {'dimension_name': 'silo', 'data_type': 'varchar'}, {'dimension_name':
'instance_type', 'data_type':
'varchar'}]
memory_cached double [{'dimension_name':
'availability_zone', 'data_type':
'varchar'}, {'dimension_name':
'microservice_name', 'data_type':
'varchar'}, {'dimension_name':
'instance_name', 'data_type':
'varchar'}, {'dimension_name':
'os_version', 'data_type':
'varchar'}, {'dimension_name':
'cell', 'data_type': 'varchar'}, {'dimension_name': 'region', 'data_type': 'varchar'}, {'dimension_name': 'silo', 'data_type': 'varchar'}, {'dimension_name':
'instance_type', 'data_type':
'varchar'}]
measure_name data_type dimensions
memory_free double [{'dimension_name':
'availability_zone', 'data_type':
'varchar'}, {'dimension_name':
'microservice_name', 'data_type':
'varchar'}, {'dimension_name':
'instance_name', 'data_type':
'varchar'}, {'dimension_name':
'process_name', 'data_type':
'varchar'}, {'dimension_name':
'os_version', 'data_type':
'varchar'}, {'dimension_name':
'jdk_version', 'data_type':
'varchar'}, {'dimension_name':
'cell', 'data_type': 'varchar'}, {'dimension_name': 'region', 'data_type': 'varchar'}, {'dimension_name': 'silo', 'data_type': 'varchar'}, {'dimension_name':
'instance_type', 'data_type':
'varchar'}]
memory_used double [{'dimension_name':
'availability_zone', 'data_type':
'varchar'}, {'dimension_name':
'microservice_name', 'data_type':
'varchar'}, {'dimension_name':
'instance_name', 'data_type':
'varchar'}, {'dimension_name':
'os_version', 'data_type':
'varchar'}, {'dimension_name':
'cell', 'data_type': 'varchar'}, {'dimension_name': 'region', 'data_type': 'varchar'}, {'dimension_name': 'silo', 'data_type': 'varchar'}, {'dimension_name':
'instance_type', 'data_type':
'varchar'}]
measure_name data_type dimensions
network_bytes_in double [{'dimension_name':
'availability_zone', 'data_type':
'varchar'}, {'dimension_name':
'microservice_name', 'data_type':
'varchar'}, {'dimension_name':
'instance_name', 'data_type':
'varchar'}, {'dimension_name':
'os_version', 'data_type':
'varchar'}, {'dimension_name':
'cell', 'data_type': 'varchar'}, {'dimension_name': 'region', 'data_type': 'varchar'}, {'dimension_name': 'silo', 'data_type': 'varchar'}, {'dimension_name':
'instance_type', 'data_type':
'varchar'}]
network_bytes_out double [{'dimension_name':
'availability_zone', 'data_type':
'varchar'}, {'dimension_name':
'microservice_name', 'data_type':
'varchar'}, {'dimension_name':
'instance_name', 'data_type':
'varchar'}, {'dimension_name':
'os_version', 'data_type':
'varchar'}, {'dimension_name':
'cell', 'data_type': 'varchar'}, {'dimension_name': 'region', 'data_type': 'varchar'}, {'dimension_name': 'silo', 'data_type': 'varchar'}, {'dimension_name':
'instance_type', 'data_type':
'varchar'}]
task_completed bigint [{'dimension_name':
'availability_zone', 'data_type':
'varchar'}, {'dimension_name':
'microservice_name', 'data_type':
'varchar'}, {'dimension_name':
'instance_name', 'data_type':
'varchar'}, {'dimension_name':
'process_name', 'data_type':
'varchar'}, {'dimension_name':
'jdk_version', 'data_type':
'varchar'}, {'dimension_name':
'cell', 'data_type': 'varchar'}, {'dimension_name': 'region', 'data_type': 'varchar'}, {'dimension_name': 'silo', 'data_type': 'varchar'}]
measure_name data_type dimensions
availability_zonemicroservice_nameinstance_nameprocess_nameos_versionjdk_versioncell region silo instance_typemeasure_nametime measure_value::doublemeasure_value::bigintmeasure_value::varchar
availability_zonemicroservice_nameinstance_nameprocess_nameos_versionjdk_versioncell region silo instance_typemeasure_nametime measure_value::doublemeasure_value::bigintmeasure_value::varchar
availability_zonemicroservice_nameinstance_nameprocess_nameos_versionjdk_versioncell region silo instance_typemeasure_nametime measure_value::doublemeasure_value::bigintmeasure_value::varchar
availability_zonemicroservice_nameinstance_nameprocess_nameos_versionjdk_versioncell region silo instance_typemeasure_nametime measure_value::doublemeasure_value::bigintmeasure_value::varchar