Could not connect with provided configuration. Error: "port" must be in range [1, 65535]

[pmediavictor]

Hi team,

I'm encountering an issue while trying to connect ClickHouse as a destination in Airbyte.

Configuration:

Here’s the JSON request I used:

{
  "name": "Clickhouse",
  "workspaceId": "XXXX",
  "definitionId": "XXXX",
  "configuration": {
    "username": "default",
    "protocol": "https",
    "password": "******",
    "database": "default",
    "port": "8443",
    "host": "https://XXXXXx.clickhouse.cloud"
  }
}

Error:

Could not connect with provided configuration. Error: "port" must be in range [1, 65535]

Diagnosis:

From the logs, it looks like the port is being treated as a string instead of an integer, which causes validation to fail in the ClickHouse Java client.

Suggested Fix:

Airbyte should parse or cast "port" to an integer before passing it to the ClickHouse client.

Alternatively, if this is an input validation issue, the UI/connector should enforce the correct data type (number, not string) for port.

Request:

Could you please confirm if this is a bug or if there’s a workaround (e.g. editing JSON schema)? Happy to help test a patch or PR if needed.

Thanks!

[marcosmarxm]

Please report this as an issue and inform what version of connector are you using.