Using Druid : 0.9.1.1.
I was expecting one my fields which stores type of payment_methods to be classified as "category". This would have helped me use this as a dashboard filter. I have confirmed that this field has 6 unique values so it is well below the limit of 40 that is documented in the other topics .. I tried to use "Sync" button to see if I find any errors in the logs. But I do not. It shows 67% analyzed for this druid table.. in case not being at 100% is a problem.
08-23 18:11:51 INFO sync-database.analyze :: [*********************************·················] 67% Analyzed table 'billdata-1'.
Interestingly, another field "status" in this table which has 3 possible values gets classified as "category"
Lastly, I inspected metabase_fieldvalues table that seems to be keeping list of unique values in the fields marked as category.. I do not see any Druid tables/fields that I have added. Should I see "status" field which was flagged as category in here ?
Any troubleshooting pointers will be a big help.
Thank you.