Hi team! For the 'file' source connector, is there a way to force the data types of the columns for csv when creating a connection? It auto's everything to string, but I know ahead what the columns datatypes will be.

Hey Callum, I don't think the local CSV destination supports this, here's a list of destinations that do: https://airbytehq.github.io/understanding-airbyte/basic-normalization/#destinations-that-support-basic-normalization The way you'd do this for connectors that do support it is in the docs: https://docs.airbyte.com/operator-guides/transformation-and-normalization/transformations-with-sql

Thanks for the reply @Nataly Merezhuk (Airbyte)! The local CSV is the source, not the destination. The destination is Postgresql. I hadn't considered using transformations to achieve this so I'll have a look!

Gotcha, sorry for misunderstanding! Then the transformations should be the way to go. The doc is a three parter, so lots to read through, but good info. Let me know if you run into any blockers with this!