6.01 Introduction to Synapse Warehouse in Microsoft Fabric

   • 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/fikrat-azizov-865a0528
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 End-To-End Tutori...  
Synapse Data Engineering in Microsoft Fabric:    • 3.01 Get Started With Synapse Data En...  
Real-Time Analytics in Microsoft Fabric:    • 4.01 Introduction to Real-Time Analyt...  

Official Documentation:
https://learn.microsoft.com/en-us/fab...
https://learn.microsoft.com/en-us/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