Troubleshooting models

What kind of problem are you having with your model?

• Can’t create a model.
• Can’t edit or save changes to a model.
• Model performance is poor.
• Model doesn’t work with data sandboxing.

Can’t create a model

If you don’t see the model button (three squares):

1. Check if you’re using a Metabase version that’s 0.42.0 or greater by going to the top right of the screen and clicking on the gear icon > About Metabase.
2. Clear your browser cache.
3. Ask your Metabase admin to clear the proxy cache (if you’re using one).
4. Ask your Metabase admin if nested queries are enabled under Admin > Settings > General.

Can’t edit or save changes to a model

If your changes to a model’s metadata or underlying question aren’t showing up:

1. Refresh your browser to confirm you’re not viewing cached results.
2. Search for known model issues using the label Querying/Models. For more information, go to How to find a known bug or limitation.

Model performance is poor

1. Optimize the underlying saved question or SQL query.

   • Ask for less data.
   • For models that use SQL questions, look for bottlenecks using SQL EXPLAIN.

2. Optimize your database schemas.

   • Aggregate data ahead of time with summary tables.
   • Index frequently queried columns.
   • Denormalize your data.
   • Materialize views.
   • Pull data out of JSON and slot its keys into columns.

3. Optimize your data warehouse(s) or database(s).

   • Replicate your database.
   • Consider a database optimized for analytics.

Explanation

Models are a type of saved question, so they will only perform as fast as the original question or SQL query.

If you want to improve the performance of a model, you can make optimizations at the query, schema, or database level (depending on your data permissions, technical expertise, and willingness to tinker).

Are you still stuck?

If you can’t solve your problem using the troubleshooting guides:

• Search or ask the Metabase community.
• Search for known model issues using the label Querying/Models. For more information, go to How to find a known bug or limitation.