Quotas - Amazon Timestream

Quotas

This section describes the current quotas, also referred to as limits, in Timestream.

Default Quotas

The following table contains the Timestream quotas and the default values.

displayName description defaultValue

Databases per account

The maximum number of databases you can create per AWS account.

500

Tables per account

The maximum number of tables you can create per AWS account.

50000

Future ingestion period in minutes

The maximum lead time (in minutes) for your time series data compared to the current system time. For example, if the future ingestion period is 15 minutes, then Timestream will accept data that is up to 15 minutes ahead of the current system time.

15

Minimum retention period for memory store in hours

The minimum duration (in hours) for which data must be retained in the memory store per table.

1

Maximum retention period for memory store in hours

The maximum duration (in hours) for which data can be retained in the memory store per table.

8766

Minimum retention period for magnetic store in days

The minimum duration (in days) for which data must be retained in the magnetic store per table.

1

Maximum retention period for magnetic store in days

The maximum duration (in days) for which data can be retained in the magnetic store.

73000

Dimensions per table

The maximum number of dimensions per table.

128

Measures per table

The maximum number of measures per table.

1024

Dimension name dimension value pair size per series

The maximum size of dimension name and dimension value pair per series.

2 Kilobytes

Records per WriteRecords API request

The maximum number of records in a WriteRecords API request.

100

Throttle rate for CRUD APIs

The maximum number of Create/Update/List/Describe/Delete database/table API requests allowed per second per account, in the current region.

1

Dimension name length

The maximum number of characters for a Dimension name.

256 Bytes

Measure name length

The maximum number of characters for a Measure name.

256 Bytes

Database name length

The maximum number of characters for a Database name.

64 Bytes

Table name length

The maximum number of characters for a Table name.

64 Bytes

QueryString length in KiB

The maximum length (in KiB) of a query string in UTF-8 encoded chars for a query.

256

Execution duration for queries in hours

The maximum execution duration (in hours) for a query. Queries that take longer will timeout.

1

Metadata size for query result

The maximum metadata size for a query result.

100 Kilobytes

Data size for query result

The maximum data size for a query result.

5 Gigabytes

Supported data types

The following table describes the supported data types for measure and dimension values:

Description Timestream value

Supported data types for measure values.

Big int, double, string, boolean

Supported data types for dimension values.

String

Naming Constraints

The following table describes naming constraints:

Description Timestream value

The maximum length of a dimension or measure name.

256 bytes

The maximum length of a table name or database name.

64 bytes

The acceptable characters for table and database names.

a-z A-Z 0-9 _ (underscore) - (dash) . (dot). All names must be encoded as UTF-8, and are case sensitive. Cannot be System identifiers.

Note

Table and database names are compared using UTF-8 binary representation. This means that comparison for ASCII characters is case sensitive.

The acceptable characters for measure and dimension names.

Measure names: System identifiers and colons : are not allowed. The measure name may not start with a reserved prefix (ts_, measure_value). All other UTF-8 encoded characters are allowed.

Dimension names: System identifiers or names ending with an underscore _ are not allowed. The dimension name may not start with a reserved prefix (ts_, measure_value). The dimension name must start with an uppercase or lowercase alphabet character A-Z or a-z. Alphanumeric characters and underscores (as long as the dimension name does not end with an underscore) are allowed.

Note

Dimension and measure names are compared using UTF-8 binary representation. This means that comparison for ASCII characters is case sensitive.

Reserved keywords

All of the following are reserved keywords:

  • ALTER

  • AND

  • AS

  • BETWEEN

  • BY

  • CASE

  • CAST

  • CONSTRAINT

  • CREATE

  • CROSS

  • CUBE

  • CURRENT_DATE

  • CURRENT_TIME

  • CURRENT_TIMESTAMP

  • CURRENT_USER

  • DEALLOCATE

  • DELETE

  • DESCRIBE

  • DISTINCT

  • DROP

  • ELSE

  • END

  • ESCAPE

  • EXCEPT

  • EXECUTE

  • EXISTS

  • EXTRACT

  • FALSE

  • FOR

  • FROM

  • FULL

  • GROUP

  • GROUPING

  • HAVING

  • IN

  • INNER

  • INSERT

  • INTERSECT

  • INTO

  • IS

  • JOIN

  • LEFT

  • LIKE

  • LOCALTIME

  • LOCALTIMESTAMP

  • NATURAL

  • NORMALIZE

  • NOT

  • NULL

  • ON

  • OR

  • ORDER

  • OUTER

  • PREPARE

  • RECURSIVE

  • RIGHT

  • ROLLUP

  • SELECT

  • TABLE

  • THEN

  • TRUE

  • UESCAPE

  • UNION

  • UNNEST

  • USING

  • VALUES

  • WHEN

  • WHERE

  • WITH

System identifiers

We reserve column names “measure_value”, "ts_non_existent_col" and “time” to be Timestream system identifiers. Additionally, column names may not start with “ts_” or “measure_name”. System identifiers are case sensitive. Identifiers compared using UTF-8 binary representation. This means that comparison for identifiers is case sensitive.

Note

System identifiers may not be used for database, table, dimension or measure names.