Airbyte is an open-source data integration engine that helps you consolidate your data in your data warehouses, lakes and databases.

Airbyte

Hello!
Please tell me if the Arbyte service can help in our task: it is necessary to transfer data from Google Bigquery to Clickhouse. If yes, how long (a few days or a few hours) can it take to migrate a 1.8 Tbyte table with 1000000000 (1 billion) rows?

Will depends on your network connection from BQ to Clickhouse, this is not simple to answer. You can run some tests to extrapolate the time will consume to finish your project

<https://discuss.airbyte.io/t/is-it-possible-to-estimate-the-time-to-transfer-my-data/353>