Filter and filter widget type not showing in native query

Filter and filter widget type is not showing in the query for Metabase version v0.31.2, for database Ketto-rds: few filters are showing but not all. For database Redshift: none of the filters except date filter is showing. It is not because of the data type, I checked.
Please help.

Hi @rakeshketto
Have you checked Settings > Admin > Data Model, to make sure the Field Type is defined correctly?