56,966 blogs · [ { "id": "01a0d7d5-1ece-7161-8e32-5d27cfb5df9d", "title": "Iceberg on a single node is coming together", "url": "https://datamonkeysite.com/2026/09/21/iceberg-on-a-single-node-is-coming-together/", "published_at": "2026-09-21T13:06:59+00:00" }, { "id": "01a08768-8756-7182-87a2-901e8cab2be3", "title": "Writing Databricks Parquet That VertiPaq Likes", "url": "https://datamonkeysite.com/2026/09/09/writing-databricks-parquet-that-vertipaq-likes/", "published_at": "2026-09-09T10:11:54+00:00" }, { "id": "01a08768-875c-707b-8015-80968dfc4312", "title": "Writing Parquet That VertiPaq Likes", "url": "https://datamonkeysite.com/2026/08/29/writing-parquet-that-vertipaq-likes/", "published_at": "2026-08-29T07:15:27+00:00" }, { "id": "01a08768-875c-707b-8015-80968eded387", "title": "The Enterprise Context Layer", "url": "https://datamonkeysite.com/2026/08/23/the-enterprise-context-layer/", "published_at": "2026-08-23T11:21:17+00:00" }, { "id": "01a08768-875c-707b-8015-80968f83636e", "title": "AI, dbt and Iceberg are already changing data engineering", "url": "https://datamonkeysite.com/2026/08/09/ai-dbt-and-iceberg-are-already-changing-data-engineering/", "published_at": "2026-08-09T07:58:26+00:00" }, { "id": "01a08768-875c-707b-8015-80968f9cbe9d", "title": "duckrun", "url": "https://datamonkeysite.com/2026/06/23/duckrun/", "published_at": "2026-06-23T10:43:42+00:00" }, { "id": "01a08768-875c-707b-8015-80968ff1574c", "title": "How far Python alone can take you on Delta", "url": "https://datamonkeysite.com/2026/05/24/how-far-python-alone-can-take-you-on-delta/", "published_at": "2026-05-24T09:40:47+00:00" }, { "id": "01a08768-875c-707b-8015-80969050ee18", "title": "Power BI with DuckDB, 4 years later", "url": "https://datamonkeysite.com/2026/05/19/power-bi-with-duckdb-4-years-later/", "published_at": "2026-05-19T06:11:33+00:00" }, { "id": "01a08768-875c-707b-8015-809690e34ffb", "title": "Ensuring safe single-writer for DuckLake on OneLake using file lease", "url": "https://datamonkeysite.com/2026/05/16/ensuring-safe-single-writer-for-ducklake-on-onelake-using-file-lease/", "published_at": "2026-05-16T09:22:31+00:00" }, { "id": "01a08768-875c-707b-8015-8096918170bd", "title": "The Boring Reason Iceberg Matters", "url": "https://datamonkeysite.com/2026/05/09/the-boring-reason-iceberg-matters/", "published_at": "2026-05-09T11:59:58+00:00" }, { "id": "01a08768-875c-707b-8015-809691a96d35", "title": "Dynamic Vertical Scaling in Microsoft Fabric Python Notebooks", "url": "https://datamonkeysite.com/2026/04/24/dynamic-vcores-in-microsoft-fabric-python-notebooks/", "published_at": "2026-04-24T06:28:39+00:00" }, { "id": "01a0c506-3380-71ce-bd8d-99d81dc3ccfd", "title": "Text-to-SQL using Local LLMs", "url": "https://datamonkeysite.com/2026/03/31/text-to-sql-using-semantic-models-and-small-language-models/", "published_at": "2026-03-31T10:54:33+00:00" }, { "id": "01a0c506-3380-71ce-bd8d-99d81e6c73fc", "title": "Deploying to Microsoft Fabric with the Fabric CLI: First Impression", "url": "https://datamonkeysite.com/2026/03/21/deploying-to-microsoft-fabric-with-the-fabric-cli-first-impression/", "published_at": "2026-03-21T11:34:46+00:00" }, { "id": "01a0c506-3380-71ce-bd8d-99d81ebf345b", "title": "Building a Data Pipeline Using VSCode and Claude Out of Thin Air", "url": "https://datamonkeysite.com/2026/03/05/building-a-data-pipeline-using-vscode-and-claude-out-of-thin-air/", "published_at": "2026-03-05T11:13:12+00:00" }, { "id": "01a0c506-3380-71ce-bd8d-99d81f8ddf90", "title": "Python Engines current Onelake Catalog integration", "url": "https://datamonkeysite.com/2026/02/22/python-engines-current-onelake-catalog-integration/", "published_at": "2026-02-22T10:38:18+00:00" }, { "id": "01a0c506-3380-71ce-bd8d-99d8207ba172", "title": "Querying a Onelake Table with RLS and CLS Using DuckDB’s MSSQL Extension", "url": "https://datamonkeysite.com/2026/02/14/querying-a-fabric-lakehouse-table-with-rls-and-cls-using-duckdbs-mssql-extension/", "published_at": "2026-02-14T11:55:33+00:00" }, { "id": "01a0c506-3380-71ce-bd8d-99d82134d7e4", "title": "Writing to SQL Server using DuckDB", "url": "https://datamonkeysite.com/2026/02/11/writing-to-sql-server-using-duckdb/", "published_at": "2026-02-11T06:01:04+00:00" }, { "id": "01a0c506-3380-71ce-bd8d-99d8213c5c34", "title": "Query Onelake Iceberg REST catalog using Duckdb SQL", "url": "https://datamonkeysite.com/2025/12/06/query-onelake-iceberg-rest-catalog-using-duckdb-sql/", "published_at": "2025-12-06T12:48:13+00:00" }, { "id": "01a0c506-3380-71ce-bd8d-99d821e3fefc", "title": "just vorder don’t try to understand how vertipaq works", "url": "https://datamonkeysite.com/2025/11/05/just-vorder-dont-try-to-understand-how-vertipaq-works/", "published_at": "2025-11-05T13:38:56+00:00" }, { "id": "01a0c506-3380-71ce-bd8d-99d821f7b162", "title": "First Look at OneLake Diagnostics", "url": "https://datamonkeysite.com/2025/10/21/first-look-at-onelake-diagnostics/", "published_at": "2025-10-21T12:26:51+00:00" }, { "id": "01a0c517-a5c9-7046-8f26-2f7dcbb5ded5", "title": "Running DuckDB at 10 TB scale", "url": "https://datamonkeysite.com/2025/10/19/running-duckdb-at-10-tb-scale/", "published_at": "2025-10-19T13:58:14+00:00" }, { "id": "01a0c517-a5c9-7046-8f26-2f7dcc30e477", "title": "First Look at Incremental Framing in Power BI", "url": "https://datamonkeysite.com/2025/09/09/first-look-at-incremental-framing-in-power-bi/", "published_at": "2025-09-09T13:07:32+00:00" }, { "id": "01a0c517-a5c9-7046-8f26-2f7dcce84e0a", "title": "First Look at Geometry Types in Parquet", "url": "https://datamonkeysite.com/2025/09/07/first-look-at-geometry-types-in-parquet/", "published_at": "2025-09-07T13:33:13+00:00" }, { "id": "01a0c517-a5c9-7046-8f26-2f7dccfab379", "title": "Using gpt-oss 20B for Text to SQL ", "url": "https://datamonkeysite.com/2025/08/07/using-gpt-oss-20b-for-text-to-sql/", "published_at": "2025-08-07T09:04:35+00:00" }, { "id": "01a0c517-a5c9-7046-8f26-2f7dcd816c4f", "title": "AI is Coming for Us", "url": "https://datamonkeysite.com/2025/08/01/ai-is-coming-for-us/", "published_at": "2025-08-01T10:11:02+00:00" }, { "id": "01a0c517-a5c9-7046-8f26-2f7dcdb7f2f9", "title": "Does a Single-Node Python Notebook Scale?", "url": "https://datamonkeysite.com/2025/07/21/does-a-single-node-python-notebook-scale/", "published_at": "2025-07-21T12:06:47+00:00" }, { "id": "01a0c517-a5c9-7046-8f26-2f7dce292e56", "title": "Some Observations on Running TPCH 1 TB on Microsoft Fabric", "url": "https://datamonkeysite.com/2025/05/25/some-observations-on-running-tpch-1-tb-on-microsoft-fabric/", "published_at": "2025-05-25T12:54:46+00:00" }, { "id": "01a0c517-a5c9-7046-8f26-2f7dce341fa4", "title": "Stress Testing Iceberg shortcut in Onelake", "url": "https://datamonkeysite.com/2025/05/07/stress-testing-iceberg-shortcut-in-onelake/", "published_at": "2025-05-07T03:21:17+00:00" }, { "id": "01a0c517-a5c9-7046-8f26-2f7dcf10cfd0", "title": "A Non-scientific Benchmark of Text-to-SQL using Small Language Models", "url": "https://datamonkeysite.com/2025/05/05/a-non-scientific-benchmark-of-text-to-sql-using-small-models/", "published_at": "2025-05-05T06:26:35+00:00" }, { "id": "01a0c517-a5c9-7046-8f26-2f7dcf886e44", "title": "Vibe Coding a Simple SQL orchestrator in a Fabric Python Notebook", "url": "https://datamonkeysite.com/2025/04/27/vibe-coding-a-simple-sql-orchestrator-in-a-fabric-python-notebook/", "published_at": "2025-04-27T08:23:27+00:00" }, { "id": "01a0c522-a28d-716b-b6b7-f31f8708ef56", "title": "An Excel User’s Perspective on Lakehouse Architecture", "url": "https://datamonkeysite.com/2025/04/14/an-excel-users-perspective-on-lakehouse-architecture/", "published_at": "2025-04-14T03:30:33+00:00" }, { "id": "01a0c522-a28d-716b-b6b7-f31f87e5cb4e", "title": "Experimenting with Text-to-SQL: Lessons from Optimizing Product Return Analysis", "url": "https://datamonkeysite.com/2025/04/10/experimenting-with-text-to-sql-lessons-from-optimizing-product-return-analysis/", "published_at": "2025-04-10T09:57:59+00:00" }, { "id": "01a0c522-a28d-716b-b6b7-f31f88e02358", "title": "How to Read a Delta Table with Deletion Vectors and Column Mapping in Python", "url": "https://datamonkeysite.com/2025/03/19/how-to-read-a-delta-table-with-deletion-vectors-and-column-mapping-in-python/", "published_at": "2025-03-19T11:38:52+00:00" }, { "id": "01a0c522-a28d-716b-b6b7-f31f890684bf", "title": "Using OBSTORE to Load and Download Arbitrary Files to OneLake", "url": "https://datamonkeysite.com/2025/03/16/using-obstore-to-load-arbitrary-files-to-onelake/", "published_at": "2025-03-16T09:38:01+00:00" }, { "id": "01a0c522-a28d-716b-b6b7-f31f89ed2f33", "title": "LLMs Are Getting Better at SQL", "url": "https://datamonkeysite.com/2025/03/07/llms-are-getting-better-at-sql/", "published_at": "2025-03-07T07:24:26+00:00" }, { "id": "01a0c522-a28d-716b-b6b7-f31f8ac77ae9", "title": "Optimizing Fabric Capacity Consumption: A Practical Approach", "url": "https://datamonkeysite.com/2025/03/05/optimizing-fabric-capacity-consumption-a-practical-approach/", "published_at": "2025-03-05T06:42:45+00:00" }, { "id": "01a0c522-a28d-716b-b6b7-f31f8ad2d41f", "title": "Reading a Delta Table Hosted in OneLake from Snowflake", "url": "https://datamonkeysite.com/2025/02/07/reading-a-delta-table-hosted-in-onelake-from-snowflake/", "published_at": "2025-02-07T01:52:48+00:00" }, { "id": "01a0c522-a28d-716b-b6b7-f31f8b38e1e4", "title": "Reading BigQuery Iceberg Tables in Fabric", "url": "https://datamonkeysite.com/2025/02/04/reading-bigquery-iceberg-tables-in-fabric/", "published_at": "2025-02-04T11:10:44+00:00" }, { "id": "01a0c522-a28d-716b-b6b7-f31f8ba91df0", "title": "Exploring OpenDal: A Unified Approach to Object Store unstructured data", "url": "https://datamonkeysite.com/2025/01/19/exploring-opendal-a-unified-approach-to-object-store-unstructured-data/", "published_at": "2025-01-19T11:31:54+00:00" }, { "id": "01a0c522-a28d-716b-b6b7-f31f8bf3e79a", "title": "Fabric for Small Enterprises", "url": "https://datamonkeysite.com/2025/01/13/fabric-for-small-enterprises/", "published_at": "2025-01-13T10:03:18+00:00" }, { "id": "01a0c52e-2024-7338-a219-332ed32f3cfd", "title": "TPC-DS 100GB with Only 2 Cores and 16 GB of RAM", "url": "https://datamonkeysite.com/2024/12/31/tpc-ds-100gb-with-only-2-cores-and-16-gb-of-ram/", "published_at": "2024-12-31T13:37:27+00:00" }, { "id": "01a0c52e-2024-7338-a219-332ed3615028", "title": "Testing TPC-DS 10GB Hosted in Fabric OneLake Using Python Data Engines", "url": "https://datamonkeysite.com/2024/12/29/testing-tpc-ds-10gb-hosted-in-fabric-onelake-using-python-data-engines/", "published_at": "2024-12-29T10:26:58+00:00" }, { "id": "01a0c52e-2024-7338-a219-332ed4309b9d", "title": "Optimizing Parquet Layout for Power BI Direct Lake Mode", "url": "https://datamonkeysite.com/2024/12/21/optimizing-parquet-layout-for-power-bi-direct-lake-mode/", "published_at": "2024-12-21T01:11:12+00:00" }, { "id": "01a0c52e-2024-7338-a219-332ed4bc6537", "title": "Building an Ad Hoc Disk Cache with DuckDB and Fabric Notebook", "url": "https://datamonkeysite.com/2024/12/02/building-an-ad-hoc-disk-cache-with-duckdb-and-fabric-notebook/", "published_at": "2024-12-02T06:50:53+00:00" }, { "id": "01a0c52e-2024-7338-a219-332ed58af972", "title": "Smart Data Pipeline Design: Check for Delta Table Changes with Minimal Overhead", "url": "https://datamonkeysite.com/2024/11/10/smart-data-pipeline-design-check-for-delta-table-changes-with-minimal-overhead/", "published_at": "2024-11-10T12:58:27+00:00" }, { "id": "01a0c52e-2024-7338-a219-332ed6780a08", "title": "Create Iceberg Table in Azure Storage using PostgreSQL as a catalog", "url": "https://datamonkeysite.com/2024/10/22/create-iceberg-table-in-azure-storage-using-postgresql-as-a-catalog/", "published_at": "2024-10-22T11:07:54+00:00" }, { "id": "01a0c52e-2024-7338-a219-332ed6de3315", "title": "Horizontal Calculation in DuckDB SQL", "url": "https://datamonkeysite.com/2024/09/08/horizontal-calculation-in-duckdb-sql/", "published_at": "2024-09-08T13:54:18+00:00" }, { "id": "01a0c52e-2024-7338-a219-332ed7573e41", "title": "Reading Delta table in Fabric Python notebook without attaching a lakehouse. ", "url": "https://datamonkeysite.com/2024/08/26/reading-delta-table-in-fabric-python-notebook-without-attaching-a-lakehouse/", "published_at": "2024-08-26T13:04:23+00:00" }, { "id": "01a0c52e-2024-7338-a219-332ed802c82b", "title": "Building Idempotent Data Pipelines with DuckDB SQL", "url": "https://datamonkeysite.com/2024/08/05/building-idempotent-data-pipelines-with-duckdb-sql-a-practical-guide/", "published_at": "2024-08-05T07:39:32+00:00" }, { "id": "01a0c52e-2024-7338-a219-332ed8180ec7", "title": "How to attach Onelake Lakehouse to DuckDB", "url": "https://datamonkeysite.com/2024/08/03/how-to-attach-onelake-lakehouse-to-duckdb/", "published_at": "2024-08-03T13:02:11+00:00" }, { "id": "01a0c538-b612-7355-acbc-8c60d78689fa", "title": "Some observations on single node vs distributed systems. ", "url": "https://datamonkeysite.com/2024/07/21/some-observations-on-single-node-vs-distributed-systems/", "published_at": "2024-07-21T10:36:51+00:00" }, { "id": "01a0c538-b612-7355-acbc-8c60d83389f6", "title": "Process 1 Billion rows of raw csv in Fabric Notebook for less than 20 Cents ", "url": "https://datamonkeysite.com/2024/05/03/process-1-billion-rows-of-raw-csv-in-fabric-notebook-for-less-than-20-cents/", "published_at": "2024-05-03T10:04:46+00:00" }, { "id": "01a0c538-b612-7355-acbc-8c60d909963f", "title": "Sharing Public Data using Onelake, Delta and Cloudflare R2 ", "url": "https://datamonkeysite.com/2024/04/03/sharing-public-data-using-onelake-delta-and-cloudflare-r2/", "published_at": "2024-04-02T15:16:21+00:00" }, { "id": "01a0c538-b612-7355-acbc-8c60d9b1ad31", "title": "Quickly view Delta Table stats", "url": "https://datamonkeysite.com/2024/03/25/quickly-view-delta-table-stats/", "published_at": "2024-03-25T13:05:24+00:00" }, { "id": "01a0c538-b612-7355-acbc-8c60d9e8eddd", "title": "Building a cost effective solution using Fabric", "url": "https://datamonkeysite.com/2024/02/22/building-a-cost-effective-solution-using-fabric/", "published_at": "2024-02-22T12:23:29+00:00" }, { "id": "01a0c538-b612-7355-acbc-8c60da7aaf92", "title": "Use Fabric Notebook code based orchestration tool to avoid concurrent write conflicts.", "url": "https://datamonkeysite.com/2024/01/27/use-fabric-notebook-code-based-orchestration-tool-to-avoid-concurrency-write-conflicts/", "published_at": "2024-01-27T04:49:25+00:00" }, { "id": "01a0c538-b612-7355-acbc-8c60db5c28c0", "title": "Using Arrow and Delta Rust to transfer Data from BigQuery to Fabric OneLake", "url": "https://datamonkeysite.com/2024/01/08/using-arrow-and-delta-rust-to-transfer-data-from-bigquery-to-fabric-onelake/", "published_at": "2024-01-08T12:17:10+00:00" }, { "id": "01a0c538-b612-7355-acbc-8c60dc301aea", "title": "Using Direct Query mode with Fabric DWH", "url": "https://datamonkeysite.com/2023/12/30/using-direct-query-mode-with-fabric-dwh/", "published_at": "2023-12-30T11:32:14+00:00" }, { "id": "01a0c538-b612-7355-acbc-8c60dc4cee0a", "title": "Reading Snowflake Iceberg Table using Fabric OneLake", "url": "https://datamonkeysite.com/2023/12/16/reading-snowflake-iceberg-table-using-fabric-onelake/", "published_at": "2023-12-16T04:18:27+00:00" }, { "id": "01a0c538-b612-7355-acbc-8c60dd159980", "title": "What is Fabric DWH Bursting ", "url": "https://datamonkeysite.com/2023/11/11/what-is-fabric-dwh-bursting/", "published_at": "2023-11-11T04:53:24+00:00" }, { "id": "01a0c542-4304-73aa-8b99-00b76fb1f87e", "title": "Loading Delta Table to Fabric OneLake using Delta Rust", "url": "https://datamonkeysite.com/2023/11/01/loading-delta-table-to-fabric-onelake-using-delta-rust/", "published_at": "2023-11-01T04:12:01+00:00" }, { "id": "01a0c542-4305-7036-b1bf-8de925d60a64", "title": "Fabric : Engines Resource Consumption.", "url": "https://datamonkeysite.com/2023/10/22/fabric-engines-resource-consumption/", "published_at": "2023-10-22T11:35:09+00:00" }, { "id": "01a0c542-4305-7036-b1bf-8de9265079c5", "title": "Glaredb Storage Format", "url": "https://datamonkeysite.com/2023/09/24/glaredb-storage-format/", "published_at": "2023-09-24T10:30:58+00:00" }, { "id": "01a0c542-4305-7036-b1bf-8de9269dceac", "title": "Fabric Notebook Virtual filesystem", "url": "https://datamonkeysite.com/2023/09/14/fabric-notebook-virtual-filesystem/", "published_at": "2023-09-14T09:22:27+00:00" }, { "id": "01a0c542-4305-7036-b1bf-8de926bc2e1f", "title": "Develop Python Notebook in your laptop and use Fabric only for Production", "url": "https://datamonkeysite.com/2023/09/01/develop-python-notebook-in-your-laptop-and-use-fabric-only-for-production/", "published_at": "2023-09-01T12:42:34+00:00" }, { "id": "01a0c542-4305-7036-b1bf-8de9273e66fc", "title": "Sharing Data Between OneLake and Snowflake", "url": "https://datamonkeysite.com/2023/08/25/sharing-data-between-onelake-and-snowflake/", "published_at": "2023-08-25T10:02:45+00:00" }, { "id": "01a0c542-4305-7036-b1bf-8de9281a843e", "title": "First Look at Dataflow Gen2", "url": "https://datamonkeysite.com/2023/08/18/first-look-at-dataflow-gen2/", "published_at": "2023-08-18T11:38:31+00:00" }, { "id": "01a0c542-4305-7036-b1bf-8de92839aca9", "title": "Loading files from a folder to Fabric DWH using data Factory pipeline.", "url": "https://datamonkeysite.com/2023/08/11/loading-files-from-a-folder-to-fabric-dwh-using-data-factory-pipeline/", "published_at": "2023-08-11T02:18:15+00:00" }, { "id": "01a0c542-4305-7036-b1bf-8de92843d20d", "title": "First Look at Fabric F2 ", "url": "https://datamonkeysite.com/2023/08/05/first-look-at-fabric-f2/", "published_at": "2023-08-05T10:42:44+00:00" }, { "id": "01a0c542-4305-7036-b1bf-8de9287a2d73", "title": "Fabric Preview Pricing Misconception", "url": "https://datamonkeysite.com/2023/07/26/fabric-preview-pricing-misconception/", "published_at": "2023-07-26T12:46:32+00:00" }, { "id": "01a0c54b-2450-7333-adc0-19504206cd54", "title": "PowerBI Direct Lake misconception", "url": "https://datamonkeysite.com/2023/07/09/powerbi-direct-lake-misconception/", "published_at": "2023-07-09T09:17:10+00:00" }, { "id": "01a0c54b-2450-7333-adc0-195042a6c561", "title": "Fabric as a OS for analytics ", "url": "https://datamonkeysite.com/2023/06/29/fabric-as-a-os-for-analytics/", "published_at": "2023-06-29T06:04:48+00:00" }, { "id": "01a0c54b-2450-7333-adc0-195042f15a2d", "title": "Save Fabric Delta Tables as DuckDB file", "url": "https://datamonkeysite.com/2023/06/26/save-fabric-delta-tables-as-duckdb-file/", "published_at": "2023-06-26T00:25:46+00:00" }, { "id": "01a0c54b-2450-7333-adc0-195043b33a79", "title": "What is the Fastest Engine to sort small Data in a Fabric Notebook?", "url": "https://datamonkeysite.com/2023/06/19/what-is-the-fastest-engine-to-sort-small-data-in-a-fabric-notebook/", "published_at": "2023-06-19T05:36:57+00:00" }, { "id": "01a0c54b-2450-7333-adc0-195043c1b040", "title": "ACID Transaction in Fabric ?", "url": "https://datamonkeysite.com/2023/06/15/acid-transaction-in-fabric/", "published_at": "2023-06-15T12:48:58+00:00" }, { "id": "01a0c54b-2450-7333-adc0-195044a0ee1c", "title": "Create Delta Table in Azure Storage using Python and serve it with Direct Lake Mode in Fabric.", "url": "https://datamonkeysite.com/2023/06/13/create-delta-table-in-azure-storage-using-python-and-serve-it-with-direct-lake-mode-in-fabric/", "published_at": "2023-06-13T06:09:05+00:00" }, { "id": "01a0c54b-2450-7333-adc0-195044c2da11", "title": "Importing Delta table from OneLake to PowerBI", "url": "https://datamonkeysite.com/2023/06/06/importing-delta-table-from-onelake-to-powerbi/", "published_at": "2023-06-06T03:36:21+00:00" }, { "id": "01a0c54b-2450-7333-adc0-195045a924ae", "title": "First Look at Fabric Serverless Spark", "url": "https://datamonkeysite.com/2023/05/30/first-look-at-fabric-serverless-spark/", "published_at": "2023-05-30T13:14:26+00:00" }, { "id": "01a0c54b-2450-7333-adc0-195045e0d16d", "title": "First impression of Microsoft Fabric", "url": "https://datamonkeysite.com/2023/05/27/first-impression-of-microsoft-fabric/", "published_at": "2023-05-27T06:22:53+00:00" }, { "id": "01a0c54b-2450-7333-adc0-195046325504", "title": "Databend and the rise of Data warehouse as a code", "url": "https://datamonkeysite.com/2023/05/22/databend-and-the-rise-of-data-warehouse-as-a-code/", "published_at": "2023-05-22T11:33:20+00:00" }, { "id": "01a0c553-862f-71c3-a3e5-7960ad008ec0", "title": "Optimize BigQuery cost by creating independent sort order for the same table", "url": "https://datamonkeysite.com/2023/04/21/optimize-bigquery-cost-by-creating-independent-sort-order-for-the-same-table/", "published_at": "2023-04-21T11:21:38+00:00" }, { "id": "01a0c553-8631-70e2-a6bb-b8d0691e236e", "title": "The Unreasonable Effectiveness of Snowflake SQL Engine", "url": "https://datamonkeysite.com/2023/04/10/the-unreasonable-effectiveness-of-snowflake-sql-engine/", "published_at": "2023-04-10T11:53:21+00:00" }, { "id": "01a0c553-8631-70e2-a6bb-b8d06a094212", "title": "First Look at Tableau Hyper", "url": "https://datamonkeysite.com/2023/03/22/first-look-at-tableau-hyper/", "published_at": "2023-03-22T04:59:15+00:00" }, { "id": "01a0c553-8631-70e2-a6bb-b8d06a6c3080", "title": "Benchmarking , Snowflake, Databricks , Synapse , BigQuery, Redshift , Trino , DuckDB and Hyper using TPCH-SF100", "url": "https://datamonkeysite.com/2023/03/09/benchmarking-snowflake-databricks-synapse-bigquery-and-duckdb-using-tpch-sf100/", "published_at": "2023-03-09T04:36:25+00:00" }, { "id": "01a0c553-8631-70e2-a6bb-b8d06b02b3eb", "title": "Implementing a Poor Man’s Lakehouse in Azure", "url": "https://datamonkeysite.com/2023/02/23/implementing-a-poor-mans-lakehouse-in-azure/", "published_at": "2023-02-23T04:44:28+00:00" }, { "id": "01a0c553-8631-70e2-a6bb-b8d06bb0f7d7", "title": "Apache Spark Benchmark for TPCH-SF10", "url": "https://datamonkeysite.com/2023/02/12/apache-spark-benchmark-for-tpch-sf10/", "published_at": "2023-02-12T06:20:26+00:00" }, { "id": "01a0c553-8631-70e2-a6bb-b8d06c38d31a", "title": "First Look at Open Table Format", "url": "https://datamonkeysite.com/2023/02/09/first-look-at-open-table-format/", "published_at": "2023-02-09T10:18:04+00:00" }, { "id": "01a0c553-8631-70e2-a6bb-b8d06d20e720", "title": "Querying Azure storage using DuckDB", "url": "https://datamonkeysite.com/2023/01/27/querying-azure-storage-using-duckdb/", "published_at": "2023-01-27T08:39:53+00:00" }, { "id": "01a0c553-8631-70e2-a6bb-b8d06d707055", "title": "Using Apache Arrow Dataset to compact old partitions", "url": "https://datamonkeysite.com/2022/12/18/using-apache-arrow-dataset-to-compact-old-partitions/", "published_at": "2022-12-18T07:24:10+00:00" }, { "id": "01a0c553-8631-70e2-a6bb-b8d06d8ecdb0", "title": "PowerBI Query plan when using Top N filter", "url": "https://datamonkeysite.com/2022/10/21/powerbi-query-plan-when-using-top-n-filter/", "published_at": "2022-10-21T10:59:56+00:00" }, { "id": "01a0c55b-fc6e-721b-8586-1acdc3b3fa08", "title": "Multi fact support in DAX and Malloy", "url": "https://datamonkeysite.com/2022/09/13/multi-fact-support-in-dax-and-malloy/", "published_at": "2022-09-13T06:55:56+00:00" }, { "id": "01a0c55b-fc6e-721b-8586-1acdc4567ca2", "title": "Running a Serverless DuckDB on Google Cloud", "url": "https://datamonkeysite.com/2022/08/27/running-a-serverless-duckdb-on-google-cloud/", "published_at": "2022-08-27T08:20:56+00:00" }, { "id": "01a0c55b-fc6e-721b-8586-1acdc53beabf", "title": "Poor Man’s lakehouse using Cloud Storage, Delta lake and DuckDB", "url": "https://datamonkeysite.com/2022/08/21/poor-mans-lakehouse-using-cloud-storage-delta-lake-and-duckdb/", "published_at": "2022-08-21T09:38:01+00:00" }, { "id": "01a0c55b-fc6e-721b-8586-1acdc5fbcc5f", "title": "Query Performance in Vertipaq vs DuckDB", "url": "https://datamonkeysite.com/2022/08/19/query-performance-in-vertipaq-vs-duckdb/", "published_at": "2022-08-19T07:20:17+00:00" }, { "id": "01a0c55b-fc6e-721b-8586-1acdc6f39861", "title": "Expanded Table Behavior in DAX and Malloy", "url": "https://datamonkeysite.com/2022/08/16/expanded-table-behavior-in-dax-and-malloy/", "published_at": "2022-08-16T04:29:34+00:00" }, { "id": "01a0c55b-fc6e-721b-8586-1acdc7a05374", "title": "Aggregate 100 GB using PowerQuery and DuckDB", "url": "https://datamonkeysite.com/2022/08/08/aggregate-100-gb-using-powerquery-and-duckdb/", "published_at": "2022-08-08T05:47:23+00:00" }, { "id": "01a0c55b-fc6f-7048-8284-e8c80f733a24", "title": "How an Open Source PowerBI Desktop May Look like", "url": "https://datamonkeysite.com/2022/07/31/how-an-open-source-powerbi-desktop-may-look-like/", "published_at": "2022-07-31T05:38:56+00:00" }, { "id": "01a0c55b-fc6f-7048-8284-e8c80f9d4161", "title": "Building Complex Data Model using Nested Data in Malloy", "url": "https://datamonkeysite.com/2022/07/26/building-complex-data-model-using-nested-data-in-malloy/", "published_at": "2022-07-26T09:53:22+00:00" }, { "id": "01a0c55b-fc6f-7048-8284-e8c8100a3563", "title": "First Look at Google Malloy", "url": "https://datamonkeysite.com/2022/07/22/first-look-at-google-malloy/", "published_at": "2022-07-22T10:51:15+00:00" }, { "id": "01a0c55b-fc6f-7048-8284-e8c81084b979", "title": "Advance Geospatial analysis using location Parameter with Streamlit", "url": "https://datamonkeysite.com/2022/07/07/advance-geospatial-analysis-using-location-parameter-with-streamlit/", "published_at": "2022-07-07T09:00:00+00:00" } ] posts Claim your blog

Back to datamonkeysite.com

Blog · corpus.blog/blogs/datamonkeysite.com/posts

datamonkeysite.com

datamonkeysite.com

2026

Iceberg on a single node is coming together original ↗

21 Sept 2026

Writing Databricks Parquet That VertiPaq Likes original ↗

9 Sept 2026

Writing Parquet That VertiPaq Likes original ↗

29 Aug 2026

The Enterprise Context Layer original ↗

23 Aug 2026

AI, dbt and Iceberg are already changing data engineering original ↗

9 Aug 2026

duckrun original ↗

23 Jun 2026

How far Python alone can take you on Delta original ↗

24 May 2026

Power BI with DuckDB, 4 years later original ↗

19 May 2026

Ensuring safe single-writer for DuckLake on OneLake using file lease original ↗

16 May 2026

The Boring Reason Iceberg Matters original ↗

9 May 2026

Dynamic Vertical Scaling in Microsoft Fabric Python Notebooks original ↗

24 Apr 2026

Text-to-SQL using Local LLMs original ↗

31 Mar 2026

Deploying to Microsoft Fabric with the Fabric CLI: First Impression original ↗

21 Mar 2026

Building a Data Pipeline Using VSCode and Claude Out of Thin Air original ↗

5 Mar 2026

Python Engines current Onelake Catalog integration original ↗

22 Feb 2026

Querying a Onelake Table with RLS and CLS Using DuckDB’s MSSQL Extension original ↗

14 Feb 2026

Writing to SQL Server using DuckDB original ↗

11 Feb 2026

2025

Query Onelake Iceberg REST catalog using Duckdb SQL original ↗

6 Dec 2025

just vorder don’t try to understand how vertipaq works original ↗

5 Nov 2025

First Look at OneLake Diagnostics original ↗

21 Oct 2025

Running DuckDB at 10 TB scale original ↗

19 Oct 2025

First Look at Incremental Framing in Power BI original ↗

9 Sept 2025

First Look at Geometry Types in Parquet original ↗

7 Sept 2025

Using gpt-oss 20B for Text to SQL original ↗

7 Aug 2025

AI is Coming for Us original ↗

1 Aug 2025

Does a Single-Node Python Notebook Scale?original ↗

21 Jul 2025

Some Observations on Running TPCH 1 TB on Microsoft Fabric original ↗

25 May 2025

Stress Testing Iceberg shortcut in Onelake original ↗

7 May 2025

A Non-scientific Benchmark of Text-to-SQL using Small Language Models original ↗

5 May 2025

Vibe Coding a Simple SQL orchestrator in a Fabric Python Notebook original ↗

27 Apr 2025

An Excel User’s Perspective on Lakehouse Architecture original ↗

14 Apr 2025

Experimenting with Text-to-SQL: Lessons from Optimizing Product Return Analysis original ↗

10 Apr 2025

How to Read a Delta Table with Deletion Vectors and Column Mapping in Python original ↗

19 Mar 2025

Using OBSTORE to Load and Download Arbitrary Files to OneLake original ↗

16 Mar 2025

LLMs Are Getting Better at SQL original ↗

7 Mar 2025

Optimizing Fabric Capacity Consumption: A Practical Approach original ↗

5 Mar 2025

Reading a Delta Table Hosted in OneLake from Snowflake original ↗

7 Feb 2025

Reading BigQuery Iceberg Tables in Fabric original ↗

4 Feb 2025

Exploring OpenDal: A Unified Approach to Object Store unstructured data original ↗

19 Jan 2025

Fabric for Small Enterprises original ↗

13 Jan 2025

2024

TPC-DS 100GB with Only 2 Cores and 16 GB of RAM original ↗

31 Dec 2024

Testing TPC-DS 10GB Hosted in Fabric OneLake Using Python Data Engines original ↗

29 Dec 2024

Optimizing Parquet Layout for Power BI Direct Lake Mode original ↗

21 Dec 2024

Building an Ad Hoc Disk Cache with DuckDB and Fabric Notebook original ↗

2 Dec 2024

Smart Data Pipeline Design: Check for Delta Table Changes with Minimal Overhead original ↗

10 Nov 2024

Create Iceberg Table in Azure Storage using PostgreSQL as a catalog original ↗

22 Oct 2024

Horizontal Calculation in DuckDB SQL original ↗

8 Sept 2024

Reading Delta table in Fabric Python notebook without attaching a lakehouse. original ↗

26 Aug 2024

Building Idempotent Data Pipelines with DuckDB SQL original ↗

5 Aug 2024

How to attach Onelake Lakehouse to DuckDB original ↗

3 Aug 2024

Some observations on single node vs distributed systems. original ↗

21 Jul 2024

Process 1 Billion rows of raw csv in Fabric Notebook for less than 20 Cents original ↗

3 May 2024

Sharing Public Data using Onelake, Delta and Cloudflare R2 original ↗

2 Apr 2024

Quickly view Delta Table stats original ↗

25 Mar 2024

Building a cost effective solution using Fabric original ↗

22 Feb 2024

Use Fabric Notebook code based orchestration tool to avoid concurrent write conflicts.original ↗

27 Jan 2024

Using Arrow and Delta Rust to transfer Data from BigQuery to Fabric OneLake original ↗

8 Jan 2024

2023

Using Direct Query mode with Fabric DWH original ↗

30 Dec 2023

Reading Snowflake Iceberg Table using Fabric OneLake original ↗

16 Dec 2023

What is Fabric DWH Bursting original ↗

11 Nov 2023

Loading Delta Table to Fabric OneLake using Delta Rust original ↗

1 Nov 2023

Fabric : Engines Resource Consumption.original ↗

22 Oct 2023

Glaredb Storage Format original ↗

24 Sept 2023

Fabric Notebook Virtual filesystem original ↗

14 Sept 2023

Develop Python Notebook in your laptop and use Fabric only for Production original ↗

1 Sept 2023

Sharing Data Between OneLake and Snowflake original ↗

25 Aug 2023

First Look at Dataflow Gen2 original ↗

18 Aug 2023

Loading files from a folder to Fabric DWH using data Factory pipeline.original ↗

11 Aug 2023

First Look at Fabric F2 original ↗

5 Aug 2023

Fabric Preview Pricing Misconception original ↗

26 Jul 2023

PowerBI Direct Lake misconception original ↗

9 Jul 2023

Fabric as a OS for analytics original ↗

29 Jun 2023

Save Fabric Delta Tables as DuckDB file original ↗

26 Jun 2023

What is the Fastest Engine to sort small Data in a Fabric Notebook?original ↗

19 Jun 2023

ACID Transaction in Fabric ?original ↗

15 Jun 2023

Create Delta Table in Azure Storage using Python and serve it with Direct Lake Mode in Fabric.original ↗

13 Jun 2023

Importing Delta table from OneLake to PowerBI original ↗

6 Jun 2023

First Look at Fabric Serverless Spark original ↗

30 May 2023

First impression of Microsoft Fabric original ↗

27 May 2023

Databend and the rise of Data warehouse as a code original ↗

22 May 2023

Optimize BigQuery cost by creating independent sort order for the same table original ↗

21 Apr 2023

The Unreasonable Effectiveness of Snowflake SQL Engine original ↗

10 Apr 2023

First Look at Tableau Hyper original ↗

22 Mar 2023

Benchmarking , Snowflake, Databricks , Synapse , BigQuery, Redshift , Trino , DuckDB and Hyper using TPCH-SF100 original ↗

9 Mar 2023

Implementing a Poor Man’s Lakehouse in Azure original ↗

23 Feb 2023

Apache Spark Benchmark for TPCH-SF10 original ↗

12 Feb 2023

First Look at Open Table Format original ↗

9 Feb 2023

Querying Azure storage using DuckDB original ↗

27 Jan 2023

2022

Using Apache Arrow Dataset to compact old partitions original ↗

18 Dec 2022

PowerBI Query plan when using Top N filter original ↗

21 Oct 2022

Multi fact support in DAX and Malloy original ↗

13 Sept 2022

Running a Serverless DuckDB on Google Cloud original ↗

27 Aug 2022

Poor Man’s lakehouse using Cloud Storage, Delta lake and DuckDB original ↗

21 Aug 2022

Query Performance in Vertipaq vs DuckDB original ↗

19 Aug 2022

Expanded Table Behavior in DAX and Malloy original ↗

16 Aug 2022

Aggregate 100 GB using PowerQuery and DuckDB original ↗

8 Aug 2022

How an Open Source PowerBI Desktop May Look like original ↗

31 Jul 2022

Building Complex Data Model using Nested Data in Malloy original ↗

26 Jul 2022

First Look at Google Malloy original ↗

22 Jul 2022

Advance Geospatial analysis using location Parameter with Streamlit original ↗

7 Jul 2022