These are the docs for the Metabase master branch. Some features documented here may not yet be available in the latest release. Check out the docs for the latest version, Metabase v0.50.
Troubleshooting SQL questions
Incorrect results
- Aggregations (counts, sums, etc.) are wrong.
- Results have duplicated rows.
- Results are missing rows.
- Dates and times are wrong.
- Data isn’t up to date.
SQL variables and field filters
- Filter widget doesn’t display a dropdown menu of values.
- SQL query contains table aliases.
- SQL syntax error: missing
FROMclause. - No option to display a filter widget.
- I don’t know the SQL variable type.
SQL syntax errors
For some common error messages, see error messages.
Working with JSON in SQL
Using the ? operator for working with JSON in SQL may cause queries to fail. On PostgreSQL, you can use ?? instead.
Are you still stuck?
If you can’t solve your problem using the troubleshooting guides:
- Search or ask the Metabase community.
- Search for known bugs or limitations.
- Hire a Metabase Expert.