mssql-python 1.10.0: Service Principal Bulk Copy, More Reliable Arrow Text, and a Core Timeout Fix
The mssql-python 1.10.0 release enhances authentication flexibility, cross-platform text reliability, and bulk load stability. A key improvement is the addition of Active Directory Service Principal support for Bulk Copy operations. This allows for tenant-aware token creation during the authentication handshake, improving enterprise automation scenarios. The library now handles Unicode text fetching more robustly by requesting SQL_CHAR values as SQL_C_WCHAR for consistent behavior across different operating systems and locales. This ensures more predictable Arrow-based reads regardless of encoding or locale configurations. The bundled Rust core dependency, mssql-py-core, has been updated to version 0.1.5. This update includes crucial fixes for bulk load connection timeout issues. Non-ASCII VARCHAR data in the Arrow fetch path is now handled correctly through UTF-16LE decoding, ensuring accuracy across various environments. Users can upgrade to the latest version using pip install --upgrade mssql-python. This update is particularly beneficial for those using Azure Entra ID authentication with Bulk Copy. The developers expressed gratitude to the community for their contributions.