PinnedPatrick PichlerinCreative DataData Warehouse (Polaris) vs. Data Lakehouse (Spark) in Microsoft FabricA comparison from a data workload perspectiveNov 9, 20232Nov 9, 20232
PinnedPatrick PichlerinCreative DataHeadless BI vs. Self-service BIBrief introduction to Headless BI and putting Power BI into its contextMar 6, 20231Mar 6, 20231
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 tablesFeb 191Feb 191
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-timeMay 19, 20221May 19, 20221
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 lakesNov 24, 2020Nov 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 APINov 9, 20221Nov 9, 20221
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 AppsOct 21, 2022Oct 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 FactorySep 15, 20224Sep 15, 20224
Patrick PichlerinCreative DataUsing Variables in Databricks WorkflowsHow to pass on values to downstream tasks in Databricks Workflows by leveraging Job Task ValuesJul 21, 2022Jul 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 dataApr 21, 2022Apr 21, 2022