Skip to main content
Version: 1.7 (Latest)

SQL Server → Parquet

Datatypes conversion mapping when exporting from SQL Server (--connectiontype mssql) to Parquet format.

SourceSQL Server (mssql)
FormatParquet
FastBCP1.4.0.0 (SQL Server 2025 types: 1.6.4.0)
Test StatusPARTIAL (32/33 Nullable) — vector not supported

Parquet Schema: testdatatypes_nullable​

namephysical_typeconverted_typelogical_type
col_bigintINT64INT_64IntType(bitWidth=64, isSigned=1)
col_intINT32INT_32IntType(bitWidth=32, isSigned=1)
col_smallintINT32INT_16IntType(bitWidth=16, isSigned=1)
col_tinyintINT32UINT_8IntType(bitWidth=8, isSigned=0)
col_bitBOOLEAN——
col_decimalINT64DECIMALDecimalType(scale=2, precision=18)
col_numericINT64DECIMALDecimalType(scale=2, precision=18)
col_moneyFIXED_LEN_BYTE_ARRAYDECIMALDecimalType(scale=4, precision=19)
col_smallmoneyINT64DECIMALDecimalType(scale=4, precision=10)
col_floatDOUBLE——
col_realFLOAT——
col_dateINT32DATE—
col_timeINT64—TimeType(isAdjustedToUTC=0, unit=MICROS)
col_datetimeINT64TIMESTAMP_MILLIS—
col_datetime2INT64TIMESTAMP_MILLIS—
col_datetimeoffsetBYTE_ARRAYUTF8StringType()
col_smalldatetimeINT64TIMESTAMP_MILLIS—
col_charBYTE_ARRAYUTF8StringType()
col_varcharBYTE_ARRAYUTF8StringType()
col_ncharBYTE_ARRAYUTF8StringType()
col_nvarcharBYTE_ARRAYUTF8StringType()
col_textBYTE_ARRAYUTF8StringType()
col_ntextBYTE_ARRAYUTF8StringType()
col_binaryBYTE_ARRAY——
col_varbinaryBYTE_ARRAY——
col_imageBYTE_ARRAY——
col_uniqueidentifierBYTE_ARRAYUTF8StringType()
col_xmlBYTE_ARRAYUTF8StringType()
col_sql_variantBYTE_ARRAYUTF8StringType()
col_geographyBYTE_ARRAYUTF8StringType()
col_geometryBYTE_ARRAYUTF8StringType()
col_jsonBYTE_ARRAYUTF8StringType()
col_vectorBYTE_ARRAYUTF8StringType()

col_json (json) and col_vector (vector(3)) are SQL Server 2025 types, tested with FastBCP 1.6.4.0.

  • json is exported as text: the JSON document.
vector is not supported by mssql

The 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.

Copyright © 2026 Architecture & Performance.