Transformations powered by dbt or SQL.
Get the data you need in the format you want through automated and custom transformations.
Select the data streams and the columns to replicate
Airbyte supports all API streams, and lets you select the ones that you want to replicate specifically. Airbyte also offers column selection, if you want to exclude some confidential data or PIIs.
Explode nested API objects into separate tables or get nested objects in destination’s native object types (SUPER, VARIANT, JSON, etc. ). Airbyte’s normalization uses dbt to load your data in the form most appropriate for your destination.
Additional transformations with your dbt project or SQL scripts
Leverage your own dbt project or use SQL queries to further customize your transformations. Move data to the specifications of your custom use cases.