Vojtěch ŠímaData Bender

Python

3 posts on Python: benchmarks, internals and workarounds for the Microsoft data stack.

  1. 03
    Automated Delta Table Maintenance in Fabric Lakehouse (Without PySpark)

    Deep dive into Delta table internals, transaction logs, and storage layout. Master maintenance, VACUUM, and Z-Order using Python (delta-rs) in Microsoft Fabric.

  2. 02
    Power BI Write-Back to Azure SQL Database using Fabric User Data Functions

    Bypass native Fabric limitations and achieve instant Power BI write-back to Azure SQL. Learn to use User Data Functions to skip the Spark cold start.

  3. 01
    Programmatically Refresh & Sync SQL Analytics Endpoint Metadata in Microsoft Fabric

    Learn how SQL Analytics Endpoint in Microsoft Fabric works and how to fix metadata lag by calling the Refresh SQL Endpoint Metadata API before Power BI refresh.