Maintain Field Type in Native SQL

Get Help
1

Some of our database tables have a State field that is mapped in Metabase as a State, which allows Location based filtering. However, when I write the query in SQL it does not seem to maintain the Field Type. Is there a way to write a query in Native SQL but have it maintain the original Metabase mapping of the original database table?

2

Hi @nplay11
You will have to use Models:
https://www.metabase.com/docs/latest/users-guide/models.html

1 Like