I have noticed that some questions that use big tables (over 1 million records) and have over 10 columns aggregated tend to fail and it is not possible to run them again after they have failed. Message "something went wrong" (Picture below)
In the logs I am getting: "2023-08-22T16:45:40+01:00 INFO metabase.server.middleware.exceptions Request canceled before finishing."
The same query takes 10 seconds in the RedShift DB and over 40 seconds in Metabase.
So, the two issues I am finding are:
- Questions taking a long time in Metabase
- Some of these questions break and do not run again.
Is there solution for any of these issues?