Advancing Fabric - The Data Warehouse Experience

The new Microsoft Fabric platform is made up of several different user experiences, each of which sits on a different compute workload. These workloads all share the common Delta storage layer, but it's important to know how each of the experiences differ, and how to get started!

In this video Simon and Craig explore the Fabric Data Warehouse experience, building out T-SQL queries, updating data and using SQL Endpoints from both Azure Data Studio and SQL Management Studio!

[tashraf]

Thx guys. It's good to see the simple explanation of the interface and how stuff works. Can you explore) performance and explain how scalability works in fabric?

[axyz_music]

What is the use case for this warehouse? I get that it's smart to have it all in OneLake, but with the performances I see in this video, I would not be able to use this as an actual data warehouse. More than 5 seconds to select 542 rows from a table and 7 seconds to update 542 records in a table with 542 records. It's an honest question. I have a hard time to see the use case when it performs like this, am I missing something?

Edit: And almost 1 second to get an error that you're not allowed to update a lakehouse.

[Fernando_Calero]

Great video to understand the basics of the Data Warehouse experience in Fabric, thanks Simon and Craig. Also, I am a big fan of the statement at 13:33. Finally, it'd help us Craig if you could use a pointer to highlight where your cursor is. Cheers!

[bharathianjeneya]

How do we easily find the sequence of videos on data warehouse experience on fabric!

[Reitseschaatser]

Great video, thanks! It has some way to go for GA I think but the preview features are looking quite good. Especially the shortcuts that are nice way of data virtualisation is something that could really cut down on loading times and IO 'waste'.

[piniki]

Thanks, how do i create table as shortcut?

[FASILWEGAYEHU]

I dont see linked service to Filesystem!!! am i right?

[mohammedghouse]

Hey Simon,

Can you please post the link to that polaris paper?

[NickJe]

I appreciate the free fabric content but let's talk about the real elephant in the room where we actually do some proper data warehousing rather than copying data from one location to another or providing snapshots! How are we working around identity columns and merge statements in the T-SQL world? Back to old school methods?

[FASILWEGAYEHU]

how do i load varchar data more than 8000+ characters?

[Fonsmail]

my most important question; “what do I need to avoid now in order to improve my migration experience that is coming?”

[sreekanth]

Will it be easy to do lift and shift of existing data solutions to fabric ??

[robertsbd]

If I am implementing a data platform on Azure for a client now as a temporary measure for the here and now, but the plan is for a Fabric platform when that hits GA, and we plan for a lakehouse and spark centric solution. Will it be easier to migrate from Synapse or Databricks, or does it not really matter which we pick?