Summary
User is experiencing an issue where tables with normalized structure are not being created in the target Clickhouse database when setting up the connection from Postgres. They are expecting Airbyte to create tables similar to how it does in other targets like Postgres/SQL. They see tables with JSON data in the
airbyte_internaldatabase but not properly structured data in the target Clickhouse database.
Question
Hi all. I’m looking for help with Postgres → Clickhouse connection in Airbyte. I have setup like it is described in documentation. The process goes OK, reports no errors. But I see no tables with normalized structure in target Clickhouse database. Am I right Airbyte should create them like it does in Postgres/SQL/etc target? What can be a reason there are no tables created in Clickhouse? I see airbyte_internal database and tables with JSON there, but no properly structured data.
This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.