Videos by Abiola David

This video walks you through how you can use the new ai_gen function in Databricks SQL which leverages on generative AI models to process and respond to to user-provided prompts

In this video, I covered how to use Azure Databricks Activity in Fabric Data Pipeline to orchestrate ingestion of files from Databricks File System to Fabric Lakehouse as delta table.

Unlock the power of Azure Key Vault in your cloud data engineering journey! In this video, I demonstrate how to securely integrate Azure SQL Database with Fabric Warehouse using Azure Data Factory for seamless data integration. Whether you're an Azure Data Engineer, Power BI user, or just starting in cloud data engineering, this tutorial provides step-by-step guidance to boost your skills. Perfect for those exploring AWS and Google Cloud Platform. Don't miss out on this valuable tutorial for mastering data integration with Azure services!

In this new data engineering video, I covered how to architect automated cross-tenants data sharing in Microsoft Fabric focusing on Lakehouse. You will learn how to enable the share and receive external data from the Fabric Admin Portal; and create Power BI Report.

In this video, I covered how to create multi-page AI/BI dashboard in databricks leveraging unity catalog data.

In this new video, I covered how to implement and run federated queries federated queries on Google BigQuery.

In this end-to-end data engineering episode, I demonstrated how to incrementally load data from Microsoft Fabric Lakehouse to Warehouse using Dataflow and Data Pipeline.

In this new video, I covered how to use the new Lakehouse Connector in Azure Data Factory to read data from ADLS Gen2 to Fabric Lakehouse as a delta table and also to write data from the Lakehouse to ADLS Gen2.

In this new video, I demonstrated how to implement automated incremental data loading using Change Data Capture technique in Azure Data Factory.

In this video, I covered how to use the Preserve Hierarchy in Azure Data Factory Copy Behaviour.

In this Data engineering episode, I covered how to read multiple CSV files from GitHub Repository to Databricks Notebook for analysis.

In this video, I covered how to mirror Azure Databricks Unity Catalog in Microsoft Fabric for downstream analysis in Power BI Service.

In this video, I demo how to create Azure SQL database, create and insert records into the table, and query the data.

This video shows how to create Databricks workspace on Azure.

This video dives into performing SQL Data Analysis in Databricks Notebook.

In this episode, I covered how to Read/Write From Fabric Lakehouse to Databricks Notebook using ABFSS Protocol.

In this video, I covered how to read and analyse Azure SQL Database Table in Databricks Notebook.

In this new video, I am going to walk you through how to write data from Fabric Dataflow Gen2 to Azure SQL Database.

In this end to end video, I walked you through how to implement Azure Databricks Autoloader which allows incremental loading of new files from Azure Data Lake Storage Gen2.

In this Power Query video, I covered how to create fiscal Year and perform aggregation using Power Query M Code.

In this Data Engineering episode, I covered how to read multiple sales parquet files resident in Google Cloud Storage to Azure SQL Database leveraging Azure Data Factory.

This videos show how to use SQL and DAX languages to compute Total Sales and Total Cost achieving the same result in Fabric Warehouse and Power BI.

In this Definitive Guide to Mirror Azure SQL Database in Fabric Warehouse episode, I am going to walk you through how to -- Enabling System Assigned Managed Identity required to publish data to Fabric Onelake. -- Connect to Azure SQL logical server using SQL Server Mgt Studio. -- Create Microsoft Entra ID authenticated login in the master database. -- Switch Database we want to Mirror in Fabric. -- Create database user to connect to the Entra ID login created above. -- Create and Insert records to SalesData table and ensure it contains primary key. -- Set up Mirroring in Fabric Warehouse workspace. -- Mirror the replicated Salesdata table in SQl Analytics Endpoint. -- Create insert new records to the SalesData from the SSMS, replicate again and query the table to see new records. -- Create product table, insert records and replicate to see the new table replicated for querying. -- Talk about the observed limitation.

In this episode, I am going to walk you through how to integrate multiple category of files in ADLS Gen2 to Azure SQL Database via Azure Data Factory data pipeline activities focusing on filter and other pipeline activities.

This end-to-end video shows how to configure and build DTB model in the DTB cloud focusing on Microsoft Fabric.