Unable to find MySQL views while selecting field filter - field to map to

I have a variable that has a type field filter. On mapping it to a field I am trying to select a field from a view that I have created in MySQL table.

I have successfully run the sync and I can see the new view in the data model section.

Let me know if this is an intended behaviour that views are not being listed during field mapping or is there anything else I need to do?

Hi @arpit.goyal
Make sure that the Field Type in Admin > Data Model > (db) > (table) > (column), is one of the accepted ones:

I have set it to Category which is within the list of accepted ones.


Post "Diagnostic Info" from Admin > Troubleshooting.

Which version of MySQL?
What is the column type in the View?

Please find the diagnostic information here - https://pastebin.com/f6mJ80Qb
I am connecting to an Amazon RDS instance which is running a MariaDB version 10.5.9
The column type is a varchar in the database.

NVM @flamber

I did a sign out and sign in and it started showing up. I think this is a bug.

@arpit.goyal Changing types after you have viewed some pages creates browser caches, which are not correctly invalidated until you do a browser refresh. That's a known problem throughout Metabase, which something that we're trying to address.
For reference: https://github.com/metabase/metabase/issues/10330#issuecomment-610900593

Excellent @flamber, will stay updated with this thread.

BTW awesome tool. Kudos to the maintainers.