home User Guide Getting Started Help Center Documentation Community Training Certification
Looker keyboard_arrow_down
language keyboard_arrow_down
case_sensitive (for Models)

This page refers to the case_sensitive parameter that is part of a model.

case_sensitive can also be used as part of an Explore, described on this documentation page.

case_sensitive can also be used as part of a dimension or filter field as described on this documentation page


case_sensitive: yes



Default Value

yes, if the database dialect supports the parameter


A Boolean (yes or no)


case_sensitive determines whether filters will be treated as case-sensitive for a given model. All filters related to the model are impacted, including those added in the Explore UI, the Dashboard UI, a filter field, or a measure’s filters parameter.

case_sensitive works by adjusting the WHERE clause of the SQL that Looker generates. When case_sensitive: yes, filters are expressed with = or LIKE, such as:

WHERE name = 'bob' WHERE name LIKE '%bob%'

When case_sensitive: no, filters are expressed with ILIKE (or equivalent), such as:

WHERE name ILIKE 'bob'

Most SQL dialects support case_sensitive. However, if your SQL dialect doesn’t support the case_sensitive parameter, case sensitivity will vary according to your database setup, which will usually not be case-sensitive. Dialect support is listed below.


Make all filters case-sensitive for a model:

case_sensitive: yes

Make all filters not case-sensitive for a model:

case_sensitive: no

Common Challenges

case_sensitive Is Not Supported by Some SQL Dialects

Looker’s ability to provide case_sensitive depends on the database dialect’s ability to support this functionality. The list below shows which dialects support case_sensitive functionality in the most recent Looker release:

DataVirtuality provides a semantic data layer connecting to various database dialects. If Looker supports case_sensitive for the underlying dialects, then Looker supports case_sensitive for DataVirtuality connecting to those dialects.

Things to Know

You Can Create a Case-Sensitive Search in MySQL

It is possible to create a case-sensitive search in MySQL without using the case_sensitive parameter. In MySQL certain data types, called binary strings, store text as a series of numbers. The capitalization of the text makes a difference in the numbers that are used. Therefore, if you convert your text to a binary string, you can make searches that are case-sensitive. For example:

dimension: will_NOT_be_case_sensitive { sql: ${TABLE}.something ;; } dimension: will_be_case_sensitive { sql: CAST(${TABLE}.something AS BINARY) ;; }