Context
As a data analyst, we've created models on a Postgres database.
At first we activated the cache on models in order to run faster queries.
Problem
After deactivating caching on models, I have the following error (here the model is called mymodel)
ERROR: relation "metabase_cache_01494_59.model_1750_mymodel" does not exist
Position: 763
What is odd is that even when reactivating the cache on models, the new cache schema isn't taken into account, in our case, the new schema is metabase_cache_01494_126
but the error stills remains
We thought we could solve this by changing slightly the model query, but since the cache is "updating" (again, even though we deactivated caching on models at the database level) every N hours, the error keeps coming back.
I'm available to provide any relevant detail necessary.