Amazon Aurora DSQL now supports the JSON data type with compression

Amazon Aurora DSQL JSON Support

Amazon Aurora DSQL now supports the PostgreSQL JSON data type with optional compression. This allows you to use PostgreSQL's JSON type with Aurora DSQL without modification, facilitating the storage of semi-structured data such as API payloads, configuration objects, or event logs.

PostgreSQL compression is enabled by default, helping to reduce storage costs for larger JSON payloads.

What to do

• Use the JSON data type when creating or modifying tables to store semi-structured data.
• Review the Aurora DSQL documentation for supported data types.
• Get started with Aurora DSQL for free using the AWS Free Tier.
• Check the AWS Region table for regional availability.
• Visit the Aurora DSQL webpage for more information.

Source: AWS release notes

If you need further guidance on AWS, our experts are available at AWS@westloop.io. You may also reach us by submitting the Contact Us form.