Data types in Amazon QLDB - Amazon Quantum Ledger Database (Amazon QLDB)

Data types in Amazon QLDB

Important

End of support notice: Existing customers will be able to use Amazon QLDB until end of support on 07/31/2025. For more details, see Migrate an Amazon QLDB Ledger to Amazon Aurora PostgreSQL.

Amazon QLDB stores documents in Amazon Ion format. Amazon Ion is a data serialization format (both in text form and in binary-encoded form) that is a superset of JSON. The following table lists the Ion data types that you can use in QLDB documents.

Data type Description
null A generic null value
bool Boolean values
int Signed integers of arbitrary size
decimal Decimal-encoded real numbers of arbitrary precision
float Binary-encoded floating point numbers (64-bit IEEE)
timestamp Date/time/timezone moments of arbitrary precision
string Unicode text literals
symbol Unicode symbolic atoms (identifiers)
blob Binary data of user-defined encoding
clob Text data of user-defined encoding
struct Unordered collections of name-value pairs
list Ordered heterogeneous collections of values

See the Ion specification document on the Amazon GitHub site for a full list of Ion core data types with complete descriptions and value formatting details.