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

Airbyte

Hi Folks,

Can Airbyte will support below?
1. Column level filtering to Destination (specific columns should be replicate from source to destination).
2. If we add/drop any column in the source then will it add/drop to the destination.
3. Rename column from source to destination ?
4. Change column data type from source to destination?
5. Rename table from source to destination?
NOTE: My Source DB is *MySQL* and Destination DB is *Google BigQuery.*

<@U047CMHLV5Z> Any example for using them?

<https://docs.airbyte.com/operator-guides/transformation-and-normalization/transformations-with-dbt>

Hi Naresh, Francisco is correct on using dbt! If anything is changed in the source, the schema needs to be refreshed for the destination conector to pick up on that change.

<@U03J7N20YAF> You mean if do any changes in the source schema then again we have to refresh the entire destination table freshly?

You would have to go to the Replication tab within a connection and click the **Refresh Source Schema** button to capture the new fields! Hope this helps :)