Hi all, looking for a way to configure SSL certificates for dbt normalization using Postgres destination. To provide some context, I am trying to replicate data from Postgres to Postgres on a Google Cloud SQL instance with SSL enabled. I have successfully setup the source and destinations by putting my ssl keys and certificates in /tmp/airbyte_local. However, normalization seems to be failing because it is trying to connect to my database without SSL.
Any advice on how to configure the profiles.yml to support my use case?