Hi
@Pavel B the latest improvements on postgres type handling was done in this
PR, which corresponds to the doc you linked.
In Airbyte, all sources type are converted to json schema primitive types:
• string,
• number
• object
• integer
• array
• boolean
• null
Raw data is indeed stored as JSON in your destination raw tables.
Casting operations of these type to more destination specific type is done during the transformation step with dbt.
The transformation we are operating is basic normalization, in this transformation date formats are casted to destination native type. At the moment no other specific types are handled because we want to make basic normalization as generic as possible for all destinations.
You are still free to use custom transformation in your syncs by using your own DBT project with the casting you want.
Could you let us know which redshift type you're interested in?
(
@Chris (deprecated profile) +
@Liren Tu do you want to add anything?)