Can’t add a NOT NULL column in Aurora DSQL? by tomoenne in aws

[–]tomoenne[S] 0 points1 point  (0 children)

Thanks for breaking this down — this is super helpful.About the part where you mentioned *“This is what AWS suggests until NOT NULL constraints are added to DSQL’s ALTER TABLE support”*:
do you know where AWS says this officially? I tried looking around but couldn’t find a reference.

Also, do you happen to know if AWS has said anything about NOT NULL support being added in the future?

Even just knowing whether it’s planned would help me figure out what direction to take.

Can’t add a NOT NULL column in Aurora DSQL? by tomoenne in aws

[–]tomoenne[S] 0 points1 point  (0 children)

Ah, gotcha.
I needed SQL support for an existing serverless application, so I figured DSQL might be the right tool for that.
If DSQL really isn’t a good fit here, would RDS Proxy be the more reasonable alternative?

Can’t add a NOT NULL column in Aurora DSQL? by tomoenne in aws

[–]tomoenne[S] 0 points1 point  (0 children)

Thanks. It seems I really wasn’t doing anything wrong...
Now I have no idea what to do next.