Microsoft Fabric, SQL Server Management Studio / SSMS, & Lakehoused Linked Data with NO DUPLICATION!

Опубликовано: 31 Май 2023
на канале: Tales From The Field
891
24

​‪@SQLBalls‬ continues the journey from his last video with Neeraj Jhaveri. This time he shows you how to connect with #SSMS aka #SQLServerManagementStudio to your #MicrosoftFabric Data Warehouse!! Next he shows how he can deploy tables via T-SQL Script, Load them with a pipeline, create tables with DATA from a CTAS Statement, and then using a Lakehouse link to that data with NO DUPLICATION & consume that data in a #Python dataframe! WOW!

Hold onto your seats!

The previous video with ‪@SQLBalls‬ & Neeraj Jhaveri
Introduction to Microsoft FABRIC!! How to Enroll, How to Opt in, How to build a Data Warehouse!!
   • Introduction to Microsoft FABRIC!! Ho...  

Data warehouse tutorial introduction
https://learn.microsoft.com/en-us/fab...

Lakehouse end-to-end scenario: overview and architecture
https://learn.microsoft.com/en-us/fab...

Data Factory end-to-end scenario: introduction and architecture
https://learn.microsoft.com/en-us/fab...

Chapters
00:00 Introduction
00:58 Demo - Open Microsoft Fabric DW in SSMS & Create tables
01:55 Demo - Ingest Data via Pipelines
03:57 Demo - Microsoft Fabric DW validate data
04:05 Demo - Validate Load in SSMS
04:25 Demo - CTAS in SSMS against Microsoft Fabric DW
05:06 Demo - Create a Lakehouse
05:25 Demo - Create shortcut to data in Lakehouse from Microsoft OneLake
05:49 Demo - Create a new Notebook & Ingest Data


Смотрите видео Microsoft Fabric, SQL Server Management Studio / SSMS, & Lakehoused Linked Data with NO DUPLICATION! онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Tales From The Field 31 Май 2023, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 891 раз и оно понравилось 24 людям.