Microsoft Fabric Data Warehouse Explained (Full Demo and Tour)
Вставка
- Опубліковано 20 лип 2024
- FREE 40-minute Fabric fundamentals course: www.skool.com/microsoft-fabri...
#datawarehouse #microsoftfabric
The data warehouse in Microsoft Fabric is a transactional database that you can use to store data, create views, functions, stored procedures. In this video, I take a boad look at the some of the core functionality of the Synapse Data Warehouse in Microsoft Fabric.
-DOCS-
Microsoft docs for the Data Warehouse - learn.microsoft.com/en-us/fab...
-TIMELINE-
0:00 Intro
0:15 Creating a data warehouse
2:18 First look
4:14 Data warehouse settings
4:54 More tour
6:14 Creating tables
8:09 Saving & sharing queries
10:03 Insert data
10:23 Selecting (viewing) data
10:58 Caution
11:36 Joining data
12:36 Creating views
14:42 Cross data warehouse querying
17:09 Summary
-LINKEDIN-
Not following the LinkedIn page yet? Here's the link: / learnmicrosoftfabric
-ABOUT WILL-
Hi, I'm Will! I'm hugely passionate about data and using it to create a better world. I currently work as a Consultant, focusing on Data Strategy, Data Engineering and Business Intelligence (within the Microsoft/Azure/Fabric environment). I have previously worked as a Data Scientist. I started Learn Microsoft Fabric to share my learnings on how Microsft Fabric works and help you build your career and build meaningful things in Fabric.
-SUBSCRIBE-
Not subscribed yet? You should! There are lots of new videos in the pipeline covering all aspects of Microsoft Fabric. - Наука та технологія
Fantastic demo and tour of how to use Data Warehousing in Microsoft Fabric 👌👌
Hi, have you posted a video on ingesting data in warehouse and comparing all ingestion options available for warehouse?
here you go ☺️ ua-cam.com/video/t5mUKaLWpHE/v-deo.html
But note that you can’t use a notebook to ingest data directly into a data warehouse (but you can load from a notebook into a Lakehouse and then query it from a Warehouse using the SQL endpoint)
@@LearnMicrosoftFabric great thanx 😊
When I try to reproduce the same code as you, I have this message:
The external policy action 'Microsoft.Sql/Sqlservers/Databases/Schemas/Tables/Create' was denied on the requested resource.
I suppose is something on the access permissions. How to fix this.
Thanks a lot
Hmm yeh I’m not sure to be honest without seeing it. Check that you have write permissions to the table!
Great showcase! How would you say this compares to something like snowflake?
Thanks! To be honest I have used snowflake much so can’t really comment on the comparison!
hello can you create vidoes related to piplines and dataflow
I have some videos on these topics, with more to come in the future: ua-cam.com/play/PLug2zSFKZmV3FkUFDxlyrfSJMQ3CeqyEF.html
What is difference between datawarehouse vs lakehouse
ua-cam.com/video/Cs6cEeSSTVw/v-deo.html
Hi Will can u share ur email , have a question or let me know where i can post
basically i want to use fabric and want to start with an idea on what architecture i need to follow that takes care of all my Power BI reports with setting up data warehouse for reports from different department. TO start with i might not need lot of data engg or science stuff but that will be later still want to have a setup that help now and later.. thanks
in advance
Hi feel free to join the community and ask there: www.skool.com/microsoft-fabric