Create Fabric warehouse with case insensitive collation

createwarehouse.py

# details from Article : https://learn.microsoft.com/en-us/fabric/data-warehouse/collation
# default collation is Latin1_General_100_BIN2_UTF8
# new collation is Latin1_General_100_CI_AS_KS_WS_SC_UTF8

#sempy version 0.4.0 or higher
!pip install semantic-link --q 
import json
import sempy.fabric as fabric
from sempy.fabric.exceptions import FabricHTTPException, WorkspaceNotFoundException

workspace_id=spark.conf.get("trident.workspace.id")

#Instantiate the client
client = fabric.FabricRestClient()

uri = f"https://api.fabric.microsoft.com/v1/workspaces/{workspace_id}/items"
payload = { 
  "type": "Warehouse", 
  "displayName": "CaseInsensitiveAPIDemo", 
  "description": "New warehouse with case-insensitive collatio2n", 
  "creationPayload": { 
    "defaultCollation": "Latin1_General_100_CI_AS_KS_WS_SC_UTF8" 
  } 
}

# Call the REST API
response = client.post(uri,json= payload)
display(response)

#data = json.loads(response.text)
#display(data)