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

[Jeff_Zhang]

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]

@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 

• If you want to update the Genie space, you can also do it programmatically: https://docs.databricks.com/api/azure/workspace/genie/updatespace

I hope this helps! 

[Jeff_Zhang]

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]

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]

@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.