Data Types

Data Types Mapping

Arrow Type	DuckDB Type	Notes
`Int8`	`TINYINT`
`Int16`	`SMALLINT`
`Int32`	`INTEGER`
`Int64`	`BIGINT`
`UInt8`	`UTINYINT`
`UInt16`	`USMALLINT`
`UInt32`	`UINTEGER`
`UInt64`	`UBIGINT`
`Float16`	`FLOAT`
`Float32`	`FLOAT`
`Float64`	`DOUBLE`
`Decimal128(p,s)`	`DECIMAL(p,s)`	Falls back to `VARCHAR` when precision exceeds 38
`Decimal256(p,s)`	`DECIMAL(p,s)`	Falls back to `VARCHAR` when precision exceeds 38

Nullability

Nullable source columns are nullable on the target. All columns except primary keys are nullable by default to handle CDC edge cases. Enable preserve_source_nullability to carry over NOT NULL constraints from the source schema.

Data Types Mapping

On this page