Seems like Redshift with Destinations V2 should be avoided for the time being. BEWARE! https://github.com/airbytehq/airbyte/issues/34357

We will have a new version of the connector out soon with a fix! cc @Gireesh Sreepathi (Airbyte)