Download Amazon Timestream JDBC Driver

Download the Amazon Timestream JDBC driver, copy the JDBC URL into DbSchema, and start designing schemas with ER diagrams — free Community Edition.

About the Amazon Timestream JDBC driver

A JDBC driver is a Java .jar library that lets applications connect to Amazon Timestream. DbSchema uses JDBC to reverse engineer schemas, run SQL, and generate documentation. Driver files are usually published by the database vendor or an open-source project.

JDBC URL format

Host, port, database name, and SSL options are passed in a URL starting with jdbc:. Each Amazon Timestream driver uses its own syntax — see the connection details below.

The Amazon Timestream JDBC driver

Amazon Timestream is a fast, scalable, and serverless time-series database service built for IoT and operational applications on AWS. It automatically scales to adjust capacity and performance, storing and analyzing trillions of events per day. Timestream's built-in time-series analytics functions make it straightforward to query measures and dimensions across time windows.

The Amazon Timestream JDBC URL

• Required File(s): timestream-jdbc-xxx.jar
• Java Driver Class: software.amazon.timestream.jdbc.TimestreamDriver
• JDBC URL: jdbc:timestream://Region={REGION};Database={DB}
• Website: Amazon Timestream Documentation

Requires AWS access key ID, secret access key, and region specification. The default port is 443 (HTTPS). Credentials can also be supplied via IAM roles or environment variables, making it straightforward to integrate with AWS-managed infrastructure without hardcoding secrets.

DbSchema and Amazon Timestream

DbSchema connects to Amazon Timestream using the JDBC driver, allowing you to browse time-series tables, visualize their measures and dimensions, and run SQL queries against IoT and telemetry datasets. Use the SQL editor to write time-series analytics with functions like ago() and bin().