Power BI

mssql-python 1.5 released -- Apache Arrow fetch, sql_variant, native UUIDs

Reddit r/MicrosoftFabric

Summary

We just shipped v1.5 of mssql-python, the official Python driver for SQL Server / Azure SQL / Fabric. The big addition is Arrow fetch support -- three new cursor methods: ```python cursor.execute("SELECT * FROM Sales.SalesOrderDetail") Full result as a PyArrow Table table = cursor.arrow() df = table.to_pandas() # zero-copy where possible Streaming RecordBatchReader for large results reader = cursor.arrow_reader(batch_size=8192) Single RecordBatch for manual chunking batch = cursor.arrow_batch...

Read the full article