How to use cache model


I need assistance with caching a model in Metabase. I can see that the schema is being created in my Metabase database.

Here is an image showing the schema creation:


However, when I run a simple model test, I encounter the following message:


Diagnostic info :

  "browser-info": {
    "language": "fr-FR",
    "platform": "Win32",
    "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/ Safari/537.36",
    "vendor": "Google Inc."
  "system-info": {
    "file.encoding": "Cp1252",
    "": "OpenJDK Runtime Environment",
    "java.runtime.version": "",
    "java.vendor": "Eclipse Adoptium",
    "java.vendor.url": "",
    "java.version": "",
    "": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "",
    "": "Windows Server 2016",
    "os.version": "10.0",
    "user.language": "fr",
    "user.timezone": "Europe/Paris"
  "metabase-info": {
    "databases": [
    "hosting-env": "unknown",
    "application-database": "mysql",
    "application-database-details": {
      "database": {
        "name": "MySQL",
        "version": "5.7.36"
      "jdbc-driver": {
        "name": "MariaDB Connector/J",
        "version": "2.7.6"
    "run-mode": "prod",
    "version": {
      "date": "2023-06-29",
      "tag": "v0.46.6",
      "branch": "release-x.46.x",
      "hash": "1bb88f5"
    "settings": {
      "report-timezone": null

I have enabled the model caching parameter in the following :

  1. Databases > MyDB > Turn model caching on
  2. Settings > Caching > MODELS: ENABLED

However, I am unsure if the cache data is stored in the same database as Metabase. Additionally, when attempting to cache a model from another remote database, the schema is not created in my local database where Metabase is installed.

Also when I turned on the cache model setting on the db, I got the message DONE in green.

Could you please help me identify what I might be missing or any potential solutions to this issue? Thank you!


Triggers for metabase.task.PersistenceRefresh.job

Key Description State Priority Last Fired Next Fire Time Start Time End Time Final Fire Time May Fire Again? Misfire Instruction
metabase.task.PersistenceRefresh.database.trigger.3 Refresh models for database 3 NORMAL 5 2023-08-02T16:00:00.000Z 2023-08-02T14:19:42.000Z Yes DO_NOTHING
metabase.task.PersistenceRefresh.database.trigger.4 Refresh models for database 4 NORMAL 5 2023-08-02T16:00:00.000Z 2023-08-02T14:01:24.000Z Yes DO_NOTHING

Please adjust the caching cron expression on the caching page.

Also, the cached model will be created on the data warehouse