Amazon Aurora DSQL adds JSONB support with compression
Amazon Aurora DSQL now supports PostgreSQL's JSONB data type, enabling easier storage of semi-structured data alongside relational data. This feature improves efficiency for storing payloads like configuration metadata and logs by leveraging PostgreSQL's compression, reducing storage costs. The JSONB data type is available for creating or modifying tables, with initial access potentially covered by the AWS Free Tier.
- →Amazon Aurora DSQL supports PostgreSQL JSONB data type
- →JSONB data type includes optional compression for efficiency
- →Availability and further information
Features (1) ›
- Amazon Aurora DSQL supports PostgreSQL JSONB data type
Amazon Aurora DSQL now supports PostgreSQL's JSONB data type, allowing users to store semi-structured data alongside relational data and utilize existing tools compatible with PostgreSQL's JSONB. This is beneficial for storing diverse data like system configurations, API parameters, and event logs.
Enhancements (1) ›
- JSONB data type includes optional compression for efficiency
The new JSONB data type in Aurora DSQL offers optional compression, enabled by default for PostgreSQL, which stores larger JSONB payloads more efficiently. This enhancement helps reduce storage costs by optimizing space utilization.
Notes (1) ›
- Availability and further information
Users can get started with Aurora DSQL for free using the AWS Free Tier. Detailed information on regional availability and specific data types, including JSONB, can be found in the AWS Region table and related documentation.
https://aws.amazon.com/about-aws/whats-new/2026/06/amazon-aurora-dsql-supports-jsonb/