Referencing a model in a SQL query won't use the persisted model

[paoliniluis]

Describe the bug
When referencing the model in a SQL query ( {{# ..}} ), then the query won't use the persisted model but rather will go to the actual table

Logs
NA

To Reproduce

1. Enable model caching (ensure that the model is being cached by checking the DB)
2. create a model (e.g. select * from people), cache it
3. then create a new GUI question and use the model, see that Metabase pulls the data from the cache (even when using the /dataset endpoint)
4. now create a SQL question, and reference the model as it would be a saved question with its id (e.g. select * from {{ # x }}, being x the id of the model), save it and run it. See that the model is pulled from the source tables rather than from the cache

Expected behavior
Cached models should always be pulled from the cache

Screenshots
Using GUI question

Using SQL question

Information about your Metabase Installation:

• Your browser and the version: Brave latest
• Your operating system: Pop 22.04
• Your databases: Postgres
• Metabase version: 1.44.2
• Metabase hosting environment: Docker
• Metabase internal database: Postgres

Severity
P2?

Additional context
Reported by a customer

[Mohammad-Rahmati]

Hi @dpsutton ,
I think the problem remains unsolved. Take a look at the following screen shots. The first image is a question referencing a model, and the second image is the model loading performance.

[flamber]

@Mohammad-Rahmati Your screenshots are showing you're running v44.2. The issue is fixed in upcoming v45.0

[Mohammad-Rahmati]

@flamber Thanks for the prompt reply! When do you think the new update goes live?

[flamber]

@Mohammad-Rahmati I don't know. Within a couple of months.