Load data into a warehouse in Microsoft Fabric

preview_player
Показать описание
Data warehouse in Microsoft Fabric is a comprehensive platform for data and analytics, featuring advanced query processing and full transactional T-SQL capabilities for easy data management and analysis.
Data warehouse provides a relational database for large-scale analytics. Unlike the default read-only SQL endpoint for tables defined in a Lakehouse, a data warehouse provides full SQL semantics; including the ability to insert, update, and delete data in the tables.
In this exercise, we’ll Load data into a Microsoft Fabric data warehouse using only SQL queries.
The video is based on Microsoft Lab which supports "Load data into a warehouse using T-SQL" module in Microsoft Learn (see links below).

What you'll find in this video:
00:00 Intro
01:02 Create a Lakehouse and upload file
03:27 Create a Warehouse
04:02 Create fact table, dimensions and view
08:40 Load data to the warehouse
19:18 Run analytical queries
26:10 Summary

*** Useful links: ***

*** Socials: ***

*** Hungry more? Learn with me ***

If you're reading this, please leave a like and comment for the algorithm.
Рекомендации по теме