Troubleshooting SQL questions

I’m getting a SQL syntax error

The error message:

• Appears in red text when you run a question that uses the SQL editor.
• Contains part of your SQL query, such as a column or table name.
• May also contain a three-digit API error code, such as 400 or 404.

My SQL query results are incorrect

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

My SQL variables aren’t working

What type of SQL variable are you using?

Field filter variables

• Filter widget doesn’t display a dropdown menu of values.
• SQL query contains a subquery (nested query) or CTE.
• 400 error from BigQuery.
• SQL syntax error: missing FROM clause.

Text, number, or date variables

• No option to display a filter widget.

I don’t know the variable type

• Different types of SQL variables.

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.