SQL Server → Parquet
Datatypes conversion mapping when exporting from SQL Server (--connectiontype mssql) to Parquet format.
| Source | SQL Server (mssql) |
| Format | Parquet |
| FastBCP | 1.4.0.0 (SQL Server 2025 types: 1.6.4.0) |
| Test Status | PARTIAL (32/33 Nullable) — vector not supported |
Parquet Schema: testdatatypes_nullable
| name | physical_type | converted_type | logical_type |
|---|---|---|---|
| col_bigint | INT64 | INT_64 | IntType(bitWidth=64, isSigned=1) |
| col_int | INT32 | INT_32 | IntType(bitWidth=32, isSigned=1) |
| col_smallint | INT32 | INT_16 | IntType(bitWidth=16, isSigned=1) |
| col_tinyint | INT32 | UINT_8 | IntType(bitWidth=8, isSigned=0) |
| col_bit | BOOLEAN | — | — |
| col_decimal | INT64 | DECIMAL | DecimalType(scale=2, precision=18) |
| col_numeric | INT64 | DECIMAL | DecimalType(scale=2, precision=18) |
| col_money | FIXED_LEN_BYTE_ARRAY | DECIMAL | DecimalType(scale=4, precision=19) |
| col_smallmoney | INT64 | DECIMAL | DecimalType(scale=4, precision=10) |
| col_float | DOUBLE | — | — |
| col_real | FLOAT | — | — |
| col_date | INT32 | DATE | — |
| col_time | INT64 | — | TimeType(isAdjustedToUTC=0, unit=MICROS) |
| col_datetime | INT64 | TIMESTAMP_MILLIS | — |
| col_datetime2 | INT64 | TIMESTAMP_MILLIS | — |
| col_datetimeoffset | BYTE_ARRAY | UTF8 | StringType() |
| col_smalldatetime | INT64 | TIMESTAMP_MILLIS | — |
| col_char | BYTE_ARRAY | UTF8 | StringType() |
| col_varchar | BYTE_ARRAY | UTF8 | StringType() |
| col_nchar | BYTE_ARRAY | UTF8 | StringType() |
| col_nvarchar | BYTE_ARRAY | UTF8 | StringType() |
| col_text | BYTE_ARRAY | UTF8 | StringType() |
| col_ntext | BYTE_ARRAY | UTF8 | StringType() |
| col_binary | BYTE_ARRAY | — | — |
| col_varbinary | BYTE_ARRAY | — | — |
| col_image | BYTE_ARRAY | — | — |
| col_uniqueidentifier | BYTE_ARRAY | UTF8 | StringType() |
| col_xml | BYTE_ARRAY | UTF8 | StringType() |
| col_sql_variant | BYTE_ARRAY | UTF8 | StringType() |
| col_geography | BYTE_ARRAY | UTF8 | StringType() |
| col_geometry | BYTE_ARRAY | UTF8 | StringType() |
| col_json | BYTE_ARRAY | UTF8 | StringType() |
| col_vector | BYTE_ARRAY | UTF8 | StringType() |
col_json (json) and col_vector (vector(3)) are SQL Server 2025 types, tested with FastBCP 1.6.4.0.
jsonis exported as text: the JSON document.
vector is not supported by mssqlThe export succeeds, but every vector value is written as the text Microsoft.Data.SqlTypes.SqlVector`1[System.Single] instead of the data. Use adbc_mssql, which exports a list of floats, or convert the column in --query: CAST(col_vector AS json) gives the JSON array ([0.5000000000,1.5000000000,2.5000000000]). SQL Server refuses CAST(col_vector AS nvarchar(max)) (error 42211); nvarchar(4000) and varchar(8000) work.