Model Amazon Timestream Tables, Dimensions, and Measures

Connect DbSchema to Amazon Timestream and turn the live schema into an editable visual model: explore relationships in interactive ER diagrams, plan changes on the canvas, and generate reviewed SQL scripts for deployment.

The workflow is designed for visual modeling, schema documentation, and deployment — keep an offline model in Git, collaborate across teams, and publish documentation that developers, analysts, and stakeholders can navigate in minutes.

Download DbSchema See Amazon Timestream Features Download Amazon Timestream JDBC Driver · All drivers

What happens after you download?

Get to your first Amazon Timestream schema diagram in minutes. No account, no credit card.

Install in minutes

Download the installer for Windows, macOS, or Linux and launch DbSchema. No signup required.

Connect to Amazon Timestream or open a sample

Reverse engineer an existing Amazon Timestream database or open a sample model to explore tables, relationships, and indexes.

Design, document, and deploy

Edit schema visually, generate documentation, and prepare reviewed migration scripts for safer releases.

Get Started Free

Time-Series Architecture and Schema Visualization

Amazon Timestream is a fully serverless time-series database hosted on AWS, purpose-built for storing and analyzing IoT sensor readings, application metrics, and operational telemetry at scale. Unlike relational databases, Timestream organizes data into tables that contain a mix of dimensions (categorical metadata) and measures (numeric or string observations) recorded alongside a timestamp. DbSchema connects to Timestream via the official JDBC driver and renders these tables as schema diagrams, letting you see at a glance which dimensions describe a time series and which measures are being tracked. You can group related tables into layout diagrams, annotate columns, and export the resulting documentation as HTML or PDF for engineering teams.

Download DbSchema Free See Amazon Timestream Features

Writing Time-Series SQL in the DbSchema SQL Editor

Timestream exposes a SQL dialect with specialized time functions such as ago(), bin(), and date_trunc() that make it easy to bucket data into fixed-width intervals or select rolling windows of recent measurements. DbSchema's SQL editor supports these extensions with syntax highlighting, auto-completion of table and column names, and a results grid that presents timestamped rows in a readable tabular format. You can save frequently used queries, organize them into folders, and share them with colleagues by exporting the query file. The editor also shows query execution time, which is useful when tuning time-range predicates to avoid full table scans across Timestream's magnetic storage tier.

DbSchema SQL editor running time-series queries against Amazon Timestream

Exploring Telemetry Datasets with the Data Explorer

Without writing a line of SQL, the data explorer lets you page through Timestream table contents row by row. You can filter by measure name, restrict to a specific time range using Timestream's built-in time column, and sort results by any dimension or measure value. For IoT projects this is invaluable: you can quickly spot anomalous sensor readings, verify that an ingestion pipeline is populating the expected dimensions, or sample the latest records from a fleet of devices. The explorer supports pagination across large result sets and lets you copy individual cells or entire rows to the clipboard for use in external tools.

Browsing Amazon Timestream telemetry data with DbSchema data explorer

Connect DbSchema to a Timestream Database

Because Timestream has no server instances to provision, the setup is mostly about the driver and the region:

Get the DbSchema installer for your OS; no account is needed, and Pro capabilities are open for a 15-day trial.
Download the Amazon Timestream JDBC driver (software.amazon.timestream.jdbc.TimestreamDriver) and add the JAR to DbSchema's driver configuration.
Create a connection with a URL of the form jdbc:timestream://Region={REGION};Database={DB} — for example jdbc:timestream://Region=us-east-1;Database=mydb — making sure the region matches where the database was created, since Timestream is region-scoped.
Authenticate with AWS credentials: supply an Access Key ID and Secret Access Key in the connection dialog, or configure an IAM role profile on the host machine. Timestream communicates over port 443 via HTTPS.
Connect — the JDBC driver handles connection pooling internally, and DbSchema renders the tables, dimensions, and measures as a schema diagram.

Amazon Timestream schema diagram in DbSchema showing dimensions and measures

Timestream Benefits of Working in DbSchema

See how Timestream tables, dimensions, and measures relate in a clear schema diagram, without writing documentation manually.
Group multiple Timestream tables into logical layouts for dashboards, IoT device fleets, or application metrics.
Try out bin() and date_trunc() time-bucketing logic in the SQL editor, then carry the working query over into application code.
Browse raw telemetry records directly, without AWS Console access or custom scripts.
Export offline HTML or PDF schema documentation for stakeholders who lack AWS access.

Ready to see your dimensions and measures laid out visually instead of guessing from ingestion code? Download DbSchema for free and connect to your Timestream database in minutes.

Teams working with Amazon Timestream often use these engines too. Explore dedicated guides and JDBC setup for each.