I am facing an issue.
So i have a huge data and i am loading that into metabase.
I have increased the driver timings and all.
when i run the sql query it takes 9-10 minutes and loads the data(but sometimes pops a message your question took too londg and not got response from database).
But even if it loads the data sometimes and if i try to go for any kind of visualization or any operations there is a response that your question took too long
Probably because when you are changing Viz you are re executing the query. The problem is not the Viz perse since even if you put it in a dashboard and load the dashboard it will get reexecuted.
But you need to focus on the 9-10 min loading time ... have you tried indexing or optimizing your SQL