Model Amazon Timestream Tables, Dimensions, and Measures

Timestream stores IoT readings and telemetry as tables of dimensions, measures, and timestamps. DbSchema connects over the official JDBC driver and diagrams those tables, so which dimensions describe each series — and which measures it records — stops being guesswork.

One diagram shows each table's dimensions and tracked measures
Try bin() and date_trunc() bucketing in the SQL editor first
Page through raw telemetry rows without console access or scripts
Organize device fleets and metric families into separate layouts

available for

ISO-27001 certified

Free Community Edition No signup required 15-day Architect trial included

Free Download

DbSchema diagramming Amazon Timestream tables with dimensions and measures

Trusted by teams at

The Ingestion Code Knows the Schema
Nobody Else Does

A serverless time-series database has no tables to design up front — dimensions and measures simply appear as devices write them. Six months in, the only definition of "the schema" is scattered across the services that ingest telemetry.

DbSchema reads what Timestream actually stores and puts it on a diagram: every table, its dimensions, its measures — visible instead of inferred.

See, Query & Organize
Time-Series Schemas Visually

From raw telemetry tables to a schema the whole team reads.

Reverse engineer Amazon Timestream tables into a schema diagram

Diagram What the Devices Built

Connect to a Timestream database and DbSchema renders its tables with dimensions and measures laid out — the data model your ingestion pipeline produced, made visible.

Write Amazon Timestream time-series SQL in the DbSchema editor

Tune Time-Bucketing Before It Ships

Write ago(), bin(), and date_trunc() queries with table and column completion, check the execution time, then carry the working SQL into application code.

Group Amazon Timestream tables into annotated layouts

One Layout per Fleet, Not One Pile

Group related tables into layouts per device fleet, dashboard, or metric family, and annotate columns so units and meaning travel with the diagram.

AWS Keeps the Data
The Model Keeps the Meaning

What DbSchema learns about your Timestream tables lands in a design model — a local file that documents the telemetry schema independently of any AWS session.

Read the Amazon Timestream schema model offline

Read It Offline

Open the model in a review meeting or on the train — no credentials, no console.

Version the Timestream schema model in Git

Version It in Git

Commit the model beside the ingestion service, so schema and code travel together.

Annotate Timestream dimensions and measures

Annotate Every Column

Comment dimensions and measures with units and meaning right where readers look.

Export Timestream schema documentation as HTML or PDF

Export for Stakeholders

Produce HTML or PDF documentation for engineers who lack AWS access entirely.

Reach Timestream Over HTTPS on Port 443

Add the Amazon Timestream JDBC driver (software.amazon.timestream.jdbc.TimestreamDriver) to DbSchema's driver configuration, then connect with a URL like jdbc:timestream://Region=us-east-1;Database=mydb. Timestream is region-scoped, so the region must match where the database was created. Authentication uses an AWS access key pair entered in the connection dialog, or an IAM role profile configured on the machine; traffic runs over HTTPS on port 443.