I'm trying to run Flyway migrations for Redshift Serverless, and I'm getting the following error org.flywaydb.core.internal.exception.FlywaySqlException: Unable to obtain connection from database (jdbc: :///?enableFetchRingBuffer=false) for user '': Connection to : refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
I already added the rule in my security group to allow my IP (I'm trying to run Flyway migrations locally), and also have the Publicly accessible parameter set to On, following the steps in this document, and using the endpoint given by the workspace.
I tried connecting to a SQL client, or even with another tool like QuickSight and it works perfectly, just having this issue with Flyway.
Is there any chance that these technologies are not compatible yet, or that I have to do additional configuration?
Thanks.