I can’t seem to add as a destination the Redshift Serverless data warehouse. I am running airbyte in an ec2 instance which is part of the same VPC on which the Redshift Serverless data warehouse operates.
I tried with and without passing the port and db name to the host url, but none worked. Passed the port, db name and schema name to the respective fields, but nothing happens and the attempt to connect times out.
Also, worth noting, the Redshift connector does not mention the
serverless version of Redshift, but it implies that the cluster version is being used.
Please let me know if it is working for you, and if yes, what valuable info that can help me can you share with me