PinnedPatrick PichlerinCreative DataData Warehouse (Polaris) vs. Data Lakehouse (Spark) in Microsoft FabricA comparison from a data workload perspective9 min read·Nov 9, 2023--2--2
PinnedPatrick PichlerinCreative DataHeadless BI vs. Self-service BIBrief introduction to Headless BI and putting Power BI into its context6 min read·Mar 6, 2023--1--1
PinnedPatrick PichlerinCreative DataBoosting Databricks ODBC Driver PerformanceThe top 3 aspects to consider to get the most out of the Databricks ODBC driver by interacting with Delta Lake tables6 min read·Feb 19, 2024--1--1
PinnedPatrick PichlerinCreative DataReal-time Monitoring of Apache Spark Streaming Jobs with Power BIHow to push Apache Spark’s streaming metrics into Power BI in real-time4 min read·May 19, 2022--1--1
PinnedPatrick PichlerinCreative DataDistributed Query Engines vs. Data Lake EnginesThe evolution from SQL-based query engines for big data to data lake engines including its impact on data warehouses and data lakes7 min read·Nov 24, 2020----
Patrick PichlerinCreative DataCustom Logging in Azure Data Factory and Azure Synapse AnalyticsHow to implement a custom logger for Azure Data Factory and Azure Synapse Analytics by querying pipeline run information via REST API4 min read·Nov 9, 2022--1--1
Patrick PichlerinCreative DataSending Emails natively from Azure Data Factory or Synapse PipelinesHow to send emails programmatically via the Microsoft Graph API instead of relying on any other service like Azure Logic Apps2 min read·Oct 21, 2022----
Patrick PichlerinCreative DataAutomating Export To File with Power BI ProHow to export reports programmatically with a Power BI Pro license only and send it to an arbitrary number of users via Azure Data Factory4 min read·Sep 15, 2022--4--4
Patrick PichlerinCreative DataUsing Variables in Databricks WorkflowsHow to pass on values to downstream tasks in Databricks Workflows by leveraging Job Task Values3 min read·Jul 21, 2022----
Patrick PichlerinCreative DataInteractive Analytics on Azure Event Hub with TrinoHow Trino enables you to run interactive SQL queries on top of Azure Event Hub streaming data6 min read·Apr 21, 2022----