Dashboard does not show all the fields for custom query

Reproducing the problem:

  1. Create a "native sql query", and save it.
  2. Navigate through: Ask_a_question>Custom question>Saved question and select the query saved in 1.
  3. Create a new question and summarize or filter as needed.
  4. Add it to a dashboard

(I go through steps 1 to 3 because only writing a "native sql query" does not allow the use of Metabase GUI. However, asking a question allows the use of GUI to easily summarize and filter the data) For example: the following shows that I can use the graphical query builder on a sql query by using steps 1 to 3.

The issue is that I cannot find all the fields/columns from the custom query when adding a dashboard filter. The dashboard filter shows only a few columns from the query (not all the available ones) although I am able to filter using the fields using the graphical query builder.

The above image shows a part of all the filters I can apply using the query builder. The following shows the list of columns that I can filter by when using the dashboard.

image

The Booking Channel column in the above images is no different from the other columns in terms of the data type.

What can I do to fix the issue, so that the dashboard filter includes all the fields that are available?

Hi @i.ridoy
Post "Diagnostic Info" from Admin > Troubleshooting.
Latest release is 0.44.1: https://github.com/metabase/metabase/releases/latest