AWS has enabled foreign key constraints in Aurora DSQL, allowing the database to enforce referential integrity natively. The feature supports standard referential actions such as CASCADE and SET NULL, addressing a significant gap that previously hindered adoption. This update allows applications to maintain data consistency directly within the database engine rather than relying on application-side logic.
- Foreign key support removes a major adoption blocker for Aurora DSQL users.
- Enables native enforcement of referential integrity via CASCADE and SET NULL actions.
- Shifts consistency enforcement from application code to the database layer.
- Simplifies data modeling for relational workloads migrating to DSQL.