AWS Amazon Timestream Query

Name: Amazon Timestream Query API
Brand: Amazon Timestream Query
Availability: InStock

★ Only Publicly Available OpenAPI DocumentAnalyticsBusiness IntelligenceapiKey13 EndpointsREST

For Agents

Run SQL queries and manage scheduled queries against Amazon Timestream time-series tables so an agent can read IoT, observability, and DevOps metrics on demand.

Install Jentic One Beta

Connect the Amazon Timestream Query to your agent

Jentic One is a self-hosted execution layer for AI agents. It lets your agent call the Amazon Timestream Query, or any other public or private API you need. You set the rules, the agent never sees your credentials, and every call is logged.

Two steps, two machines. Install the instance in a safe environment, then register your agent from wherever it runs.

Step 1: Jentic One Host machine

# On the machine that will host your Jentic One instance:
curl -fsSL https://raw.githubusercontent.com/jentic/jentic-one/main/tools/install.sh | sh

Step 2: Agent machine

# On the machine where your agent runs (keep this separate from the instance):
curl -fsSL https://raw.githubusercontent.com/jentic/jentic-one/main/tools/install.sh | sh
jentic register       # connects your agent to your Jentic One instance

Jentic One is in public beta. The setup above keeps your agent separate from the instance, which is what you want before using real credentials: an agent running as the same OS user as Jentic One can read its stored keys directly. Just evaluating? A single local install is fine to start. See the secure deployment guide for the tiers.

Capabilities

What an agent can do with Amazon Timestream Query API.

Run ad-hoc SQL queries against Timestream tables via Query with paginated result sets

Cancel an in-flight long-running query with CancelQuery

Create, update, delete, and describe scheduled queries that pre-aggregate time-series data

GET STARTED

Start building with Amazon Timestream Query API

Explore with Jentic

View OpenAPI Document

Use Cases

Patterns agents use Amazon Timestream Query API for, with concrete tasks.

★ Ad-Hoc Time-Series Investigation

When an SRE needs to investigate a spike, they run SQL directly against the Timestream Query API: SELECT bin(time, 1m), avg(measure_value::double) FROM iot.sensors WHERE region = 'us-east-1' AND time BETWEEN ago(1h) AND now() GROUP BY 1. The Query operation returns paginated results with QueryStatus showing rows scanned and bytes metered, and CancelQuery aborts the run if it exceeds expectations.

Call Query with QueryString 'SELECT bin(time, 1m) AS minute, avg(measure_value::double) AS avg_temp FROM "iot"."sensors" WHERE time > ago(1h) GROUP BY bin(time, 1m) ORDER BY minute', then page through Rows.

Scheduled Roll-Ups for Dashboards

Pre-aggregate raw metrics into a roll-up table that powers a Grafana or QuickSight dashboard. CreateScheduledQuery accepts a SQL statement, a ScheduleConfiguration cron expression, a TargetConfiguration writing into a destination Timestream table, and a NotificationConfiguration for SNS alerts on failure. The result is a managed materialised view of your time-series data that scales without operating extra infrastructure.

Call CreateScheduledQuery with Name 'cpu-5m-rollup', QueryString aggregating sensors by 5m bins, ScheduleConfiguration.ScheduleExpression 'cron(*/5 * * * ? *)', and TargetConfiguration writing to 'iot.sensors_5m'.

Operational Monitoring and SLA Reporting

Generate SLA reports by combining ad-hoc Query calls (for the report period) with scheduled queries (for daily and weekly roll-ups feeding the report). ListScheduledQueries lets you audit which roll-ups exist; DescribeScheduledQuery returns the SQL and schedule for compliance review. Tag scheduled queries with team and environment to drive cost allocation per business unit.

Call ListScheduledQueries, then for each ScheduledQueryArn call DescribeScheduledQuery and return Name, QueryString, ScheduleExpression, and Tags.

Agent-Driven Time-Series Q&A via Jentic

Embed a natural-language analytics agent that answers operational questions over time-series data. The agent translates the question into SQL, calls Query through Jentic without holding AWS keys, and formats the rows back into a chart or summary. For repeated questions, the agent can promote a successful query into a CreateScheduledQuery so the next answer reads from a pre-aggregated table.

Through Jentic, search for 'run a sql query on amazon timestream', load Query, and execute with QueryString containing the agent's generated SQL.

Key Endpoints

13 endpoints — jentic publishes the only available openapi specification for amazon timestream query, keeping it validated and agent-ready.

METHOD

PATH

DESCRIPTION

POST

/#X-Amz-Target=Timestream_20181101.Query

Run a SQL query against Timestream

POST

/#X-Amz-Target=Timestream_20181101.CancelQuery

Cancel an in-flight query

POST

/#X-Amz-Target=Timestream_20181101.CreateScheduledQuery

Create a scheduled query

POST

/#X-Amz-Target=Timestream_20181101.ExecuteScheduledQuery

Run a scheduled query on demand

POST

/#X-Amz-Target=Timestream_20181101.DescribeScheduledQuery

Describe a scheduled query

POST

/#X-Amz-Target=Timestream_20181101.PrepareQuery

Prepare a parameterised query

POST

/#X-Amz-Target=Timestream_20181101.Query

Run a SQL query against Timestream

POST

/#X-Amz-Target=Timestream_20181101.CancelQuery

Cancel an in-flight query

POST

/#X-Amz-Target=Timestream_20181101.CreateScheduledQuery

Create a scheduled query

POST

/#X-Amz-Target=Timestream_20181101.ExecuteScheduledQuery

Run a scheduled query on demand

POST

/#X-Amz-Target=Timestream_20181101.DescribeScheduledQuery

Describe a scheduled query

Why Jentic?

Three things that make agents converge on Jentic-routed access.

Credential isolation

AWS access keys for Amazon Timestream Query (used to compute the AWS Signature v4 HMAC in the Authorization header) are held encrypted in the Jentic vault. Agents receive scoped, short-lived execution permissions; the raw access key ID and secret access key never enter the agent's prompt or memory.

Intent-based discovery

Agents call Jentic with an intent like 'run a sql query on amazon timestream' and Jentic returns the matching Amazon Timestream Query operation along with its input schema, so the agent can invoke the right action without parsing AWS service docs.

Time to first call

Direct integration with Amazon Timestream Query: 2-4 days to wire up SigV4 signing, error handling, retries, and IAM scoping. Through Jentic: under an hour — search by intent, load the operation schema, execute.

FAQs

Specific to using Amazon Timestream Query API through Jentic.

Why is there no official OpenAPI spec for Amazon Timestream Query?

AWS does not publish an OpenAPI specification for Amazon Timestream Query; it ships Smithy models and language-specific SDKs instead. Jentic generates and maintains this OpenAPI spec so that AI agents and developers can call Amazon Timestream Query via structured tooling. It is validated against the live API and kept up to date. Get started at https://app.jentic.com/sign-up.

What authentication does Amazon Timestream Query use?

Timestream Query uses AWS SigV4 with X-Amz-Target identifying the action (e.g. Timestream_20181101.Query). It also requires endpoint discovery: clients call DescribeEndpoints first to learn the cell endpoint to sign against. Through Jentic, your AWS keys are vaulted and Jentic handles SigV4 signing.

Can I run aggregations across billions of points with Timestream Query?

Yes. The Query operation pushes filtering and aggregation down to Timestream's tiered memory and magnetic stores; queries return paginated results with QueryStatus reporting CumulativeBytesMetered. For repeated dashboards, promote the SQL into a scheduled query that writes pre-aggregated rows to a destination table.

What are the rate limits for Timestream Query?

Concurrent query limits are typically 200 per account per region with up to 5GB of data scanned per query and a 60-minute maximum runtime. Scheduled queries have separate per-account quotas. Throttling responses include the standard ThrottlingException.

How do I run a SQL query on Timestream through Jentic?

Search Jentic with 'run a sql query on amazon timestream', load the Query schema, and execute with QueryString set to your SQL and (optionally) MaxRows for pagination. Jentic returns the column metadata and Rows; pass the NextToken back into Query to continue paging.

Can Timestream Query create or drop tables?

No. This API is read-only and scheduled-query-management. Use the separate Timestream Write API (and its CreateDatabase, CreateTable operations) to manage schema, and the Write API's WriteRecords to ingest data.

How are scheduled queries billed?

Scheduled queries are billed by the bytes scanned per execution plus the writes to the target table, the same metering as ad-hoc queries. Tag scheduled queries to attribute the spend back to the owning team.

AWS Amazon Timestream Query

Connect the Amazon Timestream Query to your agent

Capabilities

Start building with Amazon Timestream Query API

Use Cases

Key Endpoints

Why Jentic?

Related APIs

FAQs