Troubleshooting SQL questions

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

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

For some common error messages, see error messages.

Using the ? operator for working with JSON in SQL may cause queries to fail. On PostgreSQL, you can use ?? instead.

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.