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.

Structured schemas

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.