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 FROM clause.
• 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.