terraform-provider-airbyte icon indicating copy to clipboard operation
terraform-provider-airbyte copied to clipboard

airbyte_source_postgres on Airbyte Cloud - ssl & tunnel_method & replication method issue

Open alex-pairault opened this issue 1 year ago • 3 comments

Hi,

Terraform version: v1.5.5 airbyte provider version: v0.3.2

I'm trying this provider and I have the following configuration in my terraform project: Capture d’écran 2023-08-23 à 10 26 34

When applying this code, I get the following error from the Airbyte API: Capture d’écran 2023-08-23 à 10 16 49

I tried by changing the method from "source_postgres_ssl_modes_require" to "source_postgres_update_ssl_modes_require" for example. I get the following code:

Capture d’écran 2023-08-23 à 10 25 33

This time the API accepted and created the resource. Capture d’écran 2023-08-23 à 10 20 57

However, in the Airbyte Cloud UI, it seems the source connection is not correctly configured. It did not take into account the following properties: SSL, Tunnel method and Replication method.

Capture d’écran 2023-08-23 à 10 22 08

It then prevents me from creating a connection with this connector as a source. I receive an unexpected error while trying to create a connection.

alex-pairault avatar Aug 23 '23 08:08 alex-pairault

Similar issue here too. I can set NO SSL and NO TUNNEL settings using the TF provider, but as shown in the screenshots above, it seems to be ignore. Additionally, if I test the connection, it fails (the connection test). However, if I manually set NO SSL and NO TUNNEL in the UI and change nothing else, the test connection suceeds.

alex-gregory-unmind avatar Aug 29 '23 13:08 alex-gregory-unmind

I have similar issue with source_postgres_replication_method_logical_replication_cdc tf plugin sends requests with "replication_method":null

nurikk-sa avatar Aug 31 '23 10:08 nurikk-sa

I am also running into this when I set ssl_mode as require and CDC enabled. I get a HTTP 422 and the provider sends a requrest with ssl_mode and CDC as null...

BillyUdders avatar Oct 13 '23 20:10 BillyUdders