topic Re: SQLWarehouse Case INsensitive in Warehousing & Analytics

SQLWarehouse Case INsensitive

andre_rizzatti — Wed, 29 May 2024 14:09:40 GMT

Good morning, is there any parameter or configuration that causes all my data to be consulted without case distinction? insensitive?

Re: SQLWarehouse Case INsensitive

raphaelblg — Wed, 29 May 2024 15:42:27 GMT

Hello @andre_rizzatti,

At the current moment SQL Warehouses don't have this option. This feature is coming soon.

Re: SQLWarehouse Case INsensitive

MarianoRanu — Wed, 09 Oct 2024 14:39:59 GMT

Hi @raphaelblg ,

do you know any update to this or any workaround?

Regards,

Mariano

Re: SQLWarehouse Case INsensitive

raphaelblg — Wed, 09 Oct 2024 14:53:41 GMT

@MarianoRanu SQL Collation support is now in private preview. If you have interest please reach out the Databricks team responsible for your company's account.

More details about release types: https://docs.databricks.com/en/release-notes/release-types.html

Re: SQLWarehouse Case INsensitive

hb0313 — Tue, 16 Dec 2025 15:52:13 GMT

Is this feature available in GA? Can you help with documentation?

Re: SQLWarehouse Case INsensitive

raphaelblg — Tue, 16 Dec 2025 16:13:34 GMT

Sure, we now have collation support: https://www.databricks.com/blog/introducing-collations-databricks

Ref: https://docs.databricks.com/aws/en/sql/language-manual/sql-ref-collation