Connector: Amazon Aurora DSQL [Destination]

[alarbada]

Resource name

Amazon DSQL

Resource link

https://aws.amazon.com/rds/aurora/dsql/

Connector type

Destination

Expected connector behavior

It should read and write data from / to the new amazon aurora dsql serverless database.

Link to the docs: https://docs.aws.amazon.com/en_us/aurora-dsql/

In theory, according to the blog:

Aurora DSQL is PostgreSQL-compatible, enabling developers to rapidly build and deploy applications using well-known relational database concepts, and the drivers, tools, and frameworks they already know.

So we might not even need a separate connector, the postgres connector could already work.

[hariso]

@alarbada Did you have a chance to check if our Pg connector works with Aurora DSQL?

[alarbada]

So I tried for a bit, got blocked with generating the password. After a while I realized that it had to be url encoded. Sadly afterwards I got these strange errors:

[alarbada]

I guess that dsql is not that much postgresql compatible after all. Maybe it is not compatible with how the postgres connector does the batch inserts?