Hi everyone, I’m facing a Normalize error when I try to sync data with Airbyte and Clickhouse. For Airbyte I’m using this docker-compose file https://github.com/airbytehq/airbyte/blob/master/docker-compose.yaml Any idea about this error? Thank you!

2022-10-18 09:52:25 [32mINFO[m i.a.w.n.NormalizationAirbyteStreamFactory(filterOutAndHandleNonAirbyteMessageLines):104 - 
2022-10-18 09:52:25 [42mnormalization[0m > Configuration:
2022-10-18 09:52:25 [42mnormalization[0m >   profiles.yml file [[32mOK found and valid[0m]
2022-10-18 09:52:25 [42mnormalization[0m >   dbt_project.yml file [[32mOK found and valid[0m]
2022-10-18 09:52:25 [32mINFO[m i.a.w.n.NormalizationAirbyteStreamFactory(filterOutAndHandleNonAirbyteMessageLines):104 - 
2022-10-18 09:52:25 [42mnormalization[0m > Required dependencies:
2022-10-18 09:52:25 [42mnormalization[0m >  - git [[32mOK found[0m]
2022-10-18 09:52:25 [32mINFO[m i.a.w.n.NormalizationAirbyteStreamFactory(filterOutAndHandleNonAirbyteMessageLines):104 - 
2022-10-18 09:52:25 [42mnormalization[0m > Connection:
2022-10-18 09:52:25 [42mnormalization[0m >   driver: native
2022-10-18 09:52:25 [42mnormalization[0m >   host: host.docker.internal
2022-10-18 09:52:25 [42mnormalization[0m >   port: 8123
2022-10-18 09:52:25 [42mnormalization[0m >   user: cuser
2022-10-18 09:52:25 [42mnormalization[0m >   schema: kronos
2022-10-18 09:52:25 [42mnormalization[0m >   secure: False
2022-10-18 09:52:25 [42mnormalization[0m >   verify: True
2022-10-18 09:52:25 [42mnormalization[0m >   connect_timeout: 10
2022-10-18 09:52:25 [42mnormalization[0m >   send_receive_timeout: 300
2022-10-18 09:52:25 [42mnormalization[0m >   sync_request_timeout: 5
2022-10-18 09:52:25 [42mnormalization[0m >   compress_block_size: 1048576
2022-10-18 09:52:25 [42mnormalization[0m >   compression: 
2022-10-18 09:52:25 [42mnormalization[0m >   custom_settings: None
2022-10-18 09:52:25 [42mnormalization[0m >   Connection test: [[31mERROR[0m]
2022-10-18 09:52:25 [32mINFO[m i.a.w.n.NormalizationAirbyteStreamFactory(filterOutAndHandleNonAirbyteMessageLines):104 - 
2022-10-18 09:52:25 [42mnormalization[0m > [31m1 check failed:[0m
2022-10-18 09:52:25 [42mnormalization[0m > dbt was unable to connect to the specified database.
2022-10-18 09:52:25 [42mnormalization[0m > The database returned the following error:
2022-10-18 09:52:25 [32mINFO[m i.a.w.n.NormalizationAirbyteStreamFactory(filterOutAndHandleNonAirbyteMessageLines):104 - 
2022-10-18 09:52:25 [42mnormalization[0m >   >Database Error
2022-10-18 09:52:25 [42mnormalization[0m >   Code: 102. Unexpected packet from server host.docker.internal:8123 (expected Hello or Exception, got Unknown packet)
2022-10-18 09:52:25 [32mINFO[m i.a.w.n.NormalizationAirbyteStreamFactory(filterOutAndHandleNonAirbyteMessageLines):104 - 
2022-10-18 09:52:25 [42mnormalization[0m > Check your database credentials and try again. For more information, visit:
2022-10-18 09:52:25 [42mnormalization[0m > <https://docs.getdbt.com/docs/configure-your-profile>

@[DEPRECATED] Marcos Marx turned this message into Zendesk ticket 2894 to ensure timely resolution!

Hey could you post the complete log file

The issue is that you have the HTTP port (8123) with the native driver (which normally works on port 9000). I'm not sure which airbyte version you are using but in some versions you have to specifically set the port 9000 in the connection dialog under "non-jdbc" port or something like that.