Fabric Monday 88: Converting Lakehouses to Case Insensitive

Описание: 🚀 Working with Microsoft Fabric Lakehouses?

Then you probably know the pain: by default, Lakehouses are case-sensitive when it comes to object names.

That means CustomerID, customerid, and CustomerId are seen as three different things… and that can break queries, joins, or integrations if your upstream sources (or people) aren’t 100% consistent.

👉 In this video, I walk through how to convert a Lakehouse to case-insensitive, step by step.

This simple change can make your environment:
✅ More robust against schema mismatches
✅ Easier to query and integrate
✅ Friendlier for BI tools and business users

Chapters

00:00 Introduction
00:10 Start
00:24 Example about case sensitive lakehouses
01:22 Configuring the workspace for case insensitive lakehouses
02:28 Creating a new case insensitive lakehouse
02:50 Create a shortcut from case insensitive to case sensitive lakehouse
03:22 Demonstrating how the data becomes case insensitive
03:52 SQL Endpoint configuration explained
04:30 Final conclusions about the conversion process



Let's connect
============
MMDPUG Meetup: https://www.meetup.com/MMDPUG/
MMDPUG Facebook Page : https://tinyurl.com/MMDPUGPAGE
MMDPUG Facebook Group : https://tinyurl.com/MMDPUGGROUP
LinkedIn:   / dennestorres  
Twitter:   / dennes  
What's App Group: https://tinyurl.com/MMDPUGCHAT
Email: [email protected]