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

Airbyte

for a new destination , Can the columns written to the table only be fixed _airbyte_ab_id, _airbyte_emitted_at, _airbyte_data, and why?

Yes, those are the three columns that one would expect to see in the raw data. If you have normalization enabled, then a separate table would extract the data from `_airbyte_data` and create a table with columns corresponding to your original data. See <https://airbyte.com/blog/understanding-data-replication-modes>


*<http://airbyte.com|airbyte.com>*
*<https://airbyte.com/blog/understanding-data-replication-modes|An overview of Airbyte’s replication modes | Airbyte>*
Learn about the differences between Airbyte’s various replication modes and how to choose the best one for your use case

For a deep dive into normalization, you may wish to look at: <https://airbyte.com/tutorials/full-data-synchronization>

<@U01MMSDJGC9> turned this thread into Zendesk ticket <https://airbyte7538.zendesk.com/agent/tickets/2863 | 2863> to ensure timely resolution!