How to create a Case Insensitive Warehouse in Microsoft Fabric
This is a quick blog post to show you how to use a Microsoft Fabric Notebook to quickly and easily create a Case Insensitive Warehouse.
Just a quick note when I talk about a Case Insensitive Warehouse, what that means is that the upper casing and lower casing of column names and text are ignored. By default, Warehouses and Lakehouse’s are case sensitive in Microsoft Fabric.
Below is the first code cell where I am using the notebookutils to get the workspace Id of the workspace I am currently in.
Next is where I am authenticating so that in the subsequent steps I can use the authentication token to create my case insensitive warehouse.
The final code cell is where I am now creating my case insensitive warehouse.
In line 12, is where I can specify that this is a Warehouse to be created.
Line 13 is where I am giving my Warehouse a name.
Line 16 is where I specify the collation which will make it case insensitive. This has to be done in order to create the warehouse with the right collation.
As shown below, this is the output I receive after running the code and it has successfully created my warehouse.
When I go into my Workspace, I can then see the warehouse as shown below.
A quick note that if I had to try and run the code again to create the warehouse, but it already exists I got the following in the response as shown below.
Thanks for reading, I hope that you found this useful.
You can get a copy of the notebook here: Fabric/Blog – Create case insensitive Warehouse.ipynb at main · GilbertQue/Fabric