Exact search not working in Purview Data Catlog

Richard Infield 20

In the documentation ([How to search the Data Catalog | Microsoft Learn](https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fzcusa.951200.xyz%2Fen-us%2Fpurview%2Fhow-to-search-catalog&data=05%7C02%7CInfieldR%40coned.com%7C815fb512c2d643c341e908dc767ce876%7Ce9aef9b725ca4518a88133e546773136%7C0%7C0%7C638515526060840643%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=YM9sNu%2Fih5kS1pvJ6fTctn1eYYGWK4pqcpFoOEHoE1g%3D&reserved=0"Original URL: https://zcusa.951200.xyz/en-us/purview/how-to-search-catalog. Click or tap if you trust this link.")) it says that the use of the “” will look for the exact matches of a value.

However, this does seem to be working as described within the Data Search feature of Purview Data Catalog. In practice if you search for instance for “acct_no” it comes back with entries that do not contain “acct_no” only and include things that just contain “acct” or “no”. By using the query of “acct AND no” I do get better results but that still is not the result that I want and it is not what is documented.

Is this a known issue?

Is it being fixed? If so, when will the fix be deployed?

Bhargava-MSFT 31,121 Reputation points Microsoft Employee

2024-05-17T18:01:48.1333333+00:00
Hello Richard Infield,

Welcome to the Microsoft Q&A forum.

I tried this on my end, and the search results are working as expected according to the documentation.

For example:

When I search using "SQLdb_", I see all results containing "SQLdb_"

When I search using "SQLdb", I see results with both "sqldb" and "sqldb_"

Could you please provide detailed screenshots of the issue you are experiencing? This will help me check with my internal team and get back to you.
Bhargava-MSFT 31,121 Reputation points Microsoft Employee

2024-05-21T20:32:04.9566667+00:00

Hello Richard Infield,

I am checking to see if you had a chance to look into my above response.
Sachin Thakur [ThinkAI] 0 Reputation points

2024-11-06T12:52:44.8533333+00:00

@bhargava, problem is even if you search an entire object name, its still doing a like search , for example even if i search for dim_customer , its still bringing results containing dim, customer , - , did you checked it that way?

Share via

Exact search not working in Purview Data Catlog

Your answer