The Fifteen-Minute Blind Spot — SQL Analytics Endpoint

The Fifteen-Minute Blind Spot — SQL Analytics Endpoint

SQL Analytics Endpoint: Read-Only by Design

Episode 10 • 2026-03-06 Duration: 10:53

The SQL Analytics Endpoint gives you T-SQL on Lakehouse data for free — but free comes with metadata sync delays, no Git integration, and silent Direct Lake fallbacks. Matthias and Fabia unpack when to use it, when to reach for a Warehouse instead, and how to avoid the traps that catch most teams.

What we discuss

  • A real-world mistake from a pre-Fabric era
  • The one question that reframes the architectural debate
  • How we got here — predecessor products and evolution
  • Why the "obvious" answer is often wrong
  • A real Reddit/Microsoft Q&A question unpacked
  • The concrete recommended architecture
  • F-SKU realism — what this actually costs
  • When the rejected approach is actually right
  • Risks of the recommended path
  • What Microsoft is shipping that changes the calculus
  • The architectural principle to take home

Key takeaways

  • So — the take-home. The SQL Analytics Endpoint is a projection, not a database. Use it for what it does brilliantly — SQL access to Delta tables with zero data duplication. But the moment you create your first view, the moment you need...
  • Fair point. And for teams that are SQL-first — BI developers, analysts who live in T-SQL — the Warehouse-only approach has real merit. You lose the zero-setup convenience, you manage a separate item, you pay for writes. But you gain...
  • Hm, let me think... because free has a price. The endpoint runs a background metadata sync process that pauses after fifteen minutes of inactivity. Your next query wakes it up, but now you're waiting for a full resync. And if you've got a...

Watch the episode

The Fabric Friday video on this topic: https://youtu.be/te3TjK0z4uI

Resources

About the show

Built on ElevenLabs voice synthesis. Matthias — cloned voice. Fabia — designed AI co-host. See Matthias live on YouTube (Fabric Friday), at his meetups, and at conferences like FabCon.

Hosted by Matthias Falland — Microsoft Data Platform MVP and community architect behind the Fabric Periodic Table. New episodes every Friday.

Submit your case

Have an architecture decision you are wrestling with? DM Matthias on LinkedIn — find him as Matthias Falland. Three to five sentences about the decision, your team size, and your current stack. We anonymize before airing.

Built on ElevenLabs voice synthesis. Brand design based on fabricperiodictable.com.

Det här avsnittet är hämtat från ett öppet RSS-flöde och publiceras inte av Podme. Det kan innehålla reklam.

Avsnitt(43)

A Label Is Not a Lock

A Label Is Not a Lock

A Label Is Not a Lock Episode 43 • 2026-10-30 Duration: 9:02 A sensitivity label says Highly Confidential in the header, but inside Fabric it never decides who opens the item. This episode traces wher...

30 Okt 9min

Five Thousand Files From a Blank Report

Five Thousand Files From a Blank Report

Five Thousand Files From a Blank Report Episode 42 • 2026-10-23 Duration: 10:17 Medallion is the recommended design approach for Fabric. It's also one building block out of five, and the one that send...

23 Okt 10min

Five Doors and One Credential

Five Doors and One Credential

Five Doors and One Credential Episode 41 • 2026-09-18 Duration: 8:45 Databricks and Fabric have five integration paths, not one. Each moves data. None moves permissions. We pull apart the one-credenti...

22 Okt 8min

Throttled by Yesterday's Refresh

Throttled by Yesterday's Refresh

Throttled by Yesterday's Refresh Episode 37 • 2026-10-16 Duration: 9:21 Fabric doesn't charge you when work happens — it spreads the cost forward into 2,880 thirty-second timepoints. That one sentence...

16 Okt 9min

Your Domain Isn't a Wall

Your Domain Isn't a Wall

Your Domain Isn't a Wall Episode 38 • 2026-10-09 Duration: 8:43 Fabric domains look like governance boundaries but the documentation says otherwise. We unpack what a domain actually gives you, the def...

9 Okt 8min

Where Do the Columns Come From?

Where Do the Columns Come From?

Where Do the Columns Come From? Episode 40 • 2026-09-25 Duration: 9:19 Cosmos DB has no schema. Delta tables need one. When mirroring bridges the two, the replicator guesses — and the guess only ever ...

6 Okt 9min

The Permission Split Inside Read-Only

The Permission Split Inside Read-Only

The Permission Split Inside Read-Only Episode 36 • 2026-10-02 Duration: 8:03 A workspace carries four boundaries — security, cost, region, lifecycle — and you configured one of them. This episode pull...

4 Sep 8min

The Snapshot Locked in a Room

The Snapshot Locked in a Room

The Snapshot Locked in a Room Episode 35 • 2026-08-28 Duration: 8:42 Graph in Fabric materializes a second copy of your data for traversal. That copy explains the staleness, the rebuild cycle, and the...

28 Aug 8min

Populärt inom Business & ekonomi

rss-hemlispodden
framgangspodden
varvet
bathina-en-podcast
rss-jossan-nina
rss-svart-marknad
uppgang-och-fall
rss-borsens-finest
rss-hos-psykologen
badfluence
rss-inga-dumma-fragor-om-pengar
avanzapodden
rss-dr-bjorklund
24fragor
rss-kort-lang-analyspodden-fran-di
rss-en-rik-historia
bilar-med-sladd
lastbilspodden
tabberaset
borsmorgon