Abiola David's contributions

In this end to end data engineering video, I covered how to prepare and executive cross-warehouse queries in Microsoft Fabric using the brand new T-SQL Notebook.

In this Databricks video, I covered how to use the Databricks SQL QUALIFY with window functions in SELECT list and in QUALIFY clause.

In Databricks SQL, nested data structures like arrays and structs allow you to elegantly manage and query complex, hierarchical data with ease, transforming intricate datasets into insightful, actionable information. In this video, I demonstrated how to create, insert, and query nested data structures seamlessly without Pyspark!

In this Data Engineering episode, I covered how to connect to files resident in on-prems folder and transform the data using Factory Data Factory dataflow gen2 and publish to the new SQL Database for downstream analysis in Power BI

In this video, I covered introduction to Microsoft Fabric Notebook talking about the different features and functionalities. I also demo how to use the notebook to implemment data visualization

In this video, I demo how to use the powerful Databricks AI_Mask Function to obfuscate sensitive data

In this end to end data engineering episode, you will learn how to implement automated data integration in Snowflake using TASK.

In this episode, I demonstrated how to author 4-level advanced CTEs query using the new Microsoft Fabric T-SQL Notebook.

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.