[Genie] Format assistance & entity match doesn't work for me

Jeff_Zhang
New Contributor III

I enable format assistance & entity match for some table fields in my genie space. But it looks like it doesn't work. 
e.g. the following field is categorical and I enable format assistance & entity match for it. The following is the generated sql:
 

move_type = 'GATE_OUT'

But what I expect is move_type = 'GATE-OUT'

To me, it looks like genie don't know the real value in move_type.
Anyone can help to fix this problem? Thanks

 



pavannaidu
Databricks Employee
Databricks Employee

@Jeff_Zhang 

It could be for a couple of reasons

1. Check if the number of distinct values in this column exceeds the current limit of 1,024 distinct values. Reference: https://docs.databricks.com/aws/en/genie/knowledge-store#-prompt-matching-components

2. Check if there are duplicate entries in the column, where both GATE_OUT & GATE-OUT exist in th column.

3. More importantly, it could be that the entity matching state is stale. The state is created when the Genie space is created. However, if the data is refreshed, you will need to manually refresh the state.

  • In UI, toggling entity matching on and off will refresh the state that is used for matching values. You will see a spinning wheel in the UI, for example, see below 

Screenshot 2026-02-06 at 12.15.00 PM.png

I hope this helps! 

Thanks @pavannaidu I am sure this column doesn't exceeds the current limit of 1,024 distinct values. And there's no duplicate GATE_OUT & GATE-OUT. And I have refreshed the entity matching several times, but doesn't work for me. 

pavannaidu
Databricks Employee
Databricks Employee

Thanks for checking, @Jeff_Zhang ! Just want to clarify regarding refreshing the state: you will need to toggle off & save, then toggle on again & save. Otherwise, format assistance/entity matching won't refresh. You will see a spinning wheel in the UI when it's refreshing. 

Additionally, do you see values such as GATE-OUT, GATE-IN, etc., in the format assistance? 

Last resort: try recreating the Genie space and see if it works. You can clone a Genie space; this will recreate the space: https://docs.databricks.com/aws/en/genie/set-up#clone-a-genie-space

Jeff_Zhang
New Contributor III

@pavannaidu I have tried all the approaches, but none of them works for me. Genie is a blackbox for me which means it is very hard for me to do the trouble shooting.