SQLWarehouse Case INsensitive

[andre_rizzatti]

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

[raphaelblg]

Hello @andre_rizzatti, 

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

[MarianoRanu]

Hi @raphaelblg ,

do you know any update to this or any workaround?

Regards,

Mariano

[raphaelblg]

@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

[hb0313]

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

[raphaelblg]

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