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

Airbyte

Hi all! Just getting started with Airbyte. I'm a current Fivetran customer and trying to see if Airbyte will solve some of our needs. The first thing I'm trying to do is clone our S3 file data sources (CSV files) to a test postgres destination and running into some issues:
1. Any null string column is written as `NaN` 
2. the column names are written in title case (eg `Job Type`) and it would be great if it could be cleaned as snake_case
3. column type mappings - seems like timestamps are kept as strings. Any control over that? 

I guess all of the above is not an "airbyte" concern but for the transformation pipeline to fix up

<@U0245BV73LP> there are some feature requests to add *Transformations/Operations,* like renaming destination columns, namespace. Soon you could do that using <https://github.com/airbytehq/airbyte/issues/2959|custom dbt> and in the future probably more generic custom operators will be able.
3. not at the moment, there are some work doing improving data types and also the custom dbt will allow you to do that