- Native Types: This adds Avro logical types to the schema, so that the pre-built pipelines can recognise, date, time, and timestamp columns and load them as the matching types. New pipelines use this by default.
- Integers from Epoch: This adds no logical types, so date, time, and timestamp columns appear as plain integers in the destination after processing by the pre-built pipelines.
If your streaming destination is Snowflake, read Streaming to a Snowflake destination for details.
The epoch integer value is the number of days since the Unix epoch for all data sources except Oracle, where it is the number of milliseconds since the Unix epoch.