Search in Azure Data Catalog key insensitive

Question

I'm trying to figure out how to search by filename in data catalog, without being key insensitive.

g.e.:

• I have 3 files: "filename.csv", "FILENAME.csv", "fileName.csv"

• I want to get just the file "filename.csv" (in lower case).

• If I search with the name:

• I am getting back the 3 files (with double quotes and without, it returns the same).

Is there any way to get back just the file in lower case? Or how can avoid the key insensitive problem?

Thanks in advance.

Cheers, Jon

Answer 1

https://learn.microsoft.com/en-us/rest/api/datacatalog/data-catalog-search-syntax-reference explains how things work. But the short version is that the search is case insensitive and there isn't a way to avoid that.