Hi, It would be great to have lakehouse and warehouse support different collations, specifically case sensitive and case insensitive. At the moment we are able to create objects that are n...
Here's the reference documenting that "identifiers are case-insensitive" in Spark SQL, which ought to be a guide for Fabric as well: https://spark.apache.org/docs/latest/sql-ref-identifier.html
Further, SQL Server's default behavior in the US is to treat SQL identifiers as case-insensitive: SQL_Latin1_General_CP1_CI_AS. https://learn.microsoft.com/en-us/sql/relational-databases/collations/set-or-change-the-server-collation
