• Microsoft Fabric For Beginners
In this video, I explain what Synapse Warehouse Service in Fabric, and what capabilities it includes.
I also explain the purpose of the Mirroring feature. Next, I explain important data ingestion architecture options and demonstrate usage of Dataflow Gen2, shortcuts and SQL commands, like COPY INTO, Create Table AS (CTAS) and INSERT INTO.
Chapters:
00:00 Introduction
00:43 Preview
03:34 Overview Synapse Warehouse Service
05:14 What is Mirroring and how it works?
05:53 What are the differences between Warehouse and Lakehouse?
07:53 Data Ingestion methods
10:27 Sample Warehouse data ingestion architecture direct ingestion
11:07 Sample Warehouse data ingestion architecture data ingestion through Lakehouse
12:45 Demo 1: Exploring sample warehouse UI walkthrough, querying
16:21 Demo 2 Exploring Visual Query feature
17:00 Demo 3: Connecting to the warehouse from SQL clients (SSMS)
17:18 Demo 4: Creating the first warehouse, schema and table objects
21:20 Demo 5: Using Dataflow Gen2 to ingest data into the warehouse
24:31 Demo 6: Using command tools for data ingestion COPY INTO command. How to handle errors?
30:44 Demo 7: Using INSERT INTO command
31:15 Demo 8: How to use shortcuts to Lakehouse tables?
You can download the demo artifacts here:
SQL Script: https://github.com/fazizov/youtube/bl...
Data:
https://github.com/fazizov/youtube/bl...
Please subscribe: / @fazizov
Follow me on Linkedin: www.linkedin.com/in/fikratazizov865a0528
and X: @fikrat_azizov
Check out these tutorials to learn more about:
Data Pipelines: • 1.02 What Are Microsoft Fabric Data ...
Dataflow Gen2: • 2.01 Dataflow Gen 2 EndToEnd Tutori...
Synapse Data Engineering in Microsoft Fabric: • 3.01 Get Started With Synapse Data En...
RealTime Analytics in Microsoft Fabric: • 4.01 Introduction to RealTime Analyt...
Official Documentation:
https://learn.microsoft.com/enus/fab...
https://learn.microsoft.com/enus/sql...
Hashtags:
#microsoftfabric ,#datawarehouse, #dataengineering, #azure,#microsoft,#cloudcomputing, #dataanalytics, #lakehouse, #azuretutorial, #azuretraining, #datapipeline, #dataextraction , #dataintegration, #datatransfer, #dataflow, #spark, #deltalake, #synapse, #synapsedataenginering, #demo, #datalake, #transformation, #ingested, #dataintegration, #azuredatabricks ,#databricks, #bigdata, #bigdatatechnologies, #pyspark, #sparksql, #notebook ,#transformationvideo, #bronze, #medallion , #modeling, #facts, #silver, #gold, #historical data, #timetravel, #incremental,#datafactory, #dataactivator, #mirroring