Redshift has a bug, when you have a view that references a bunch of spectrum tables, it takes extremely long to plan the query before returning nothing to the metabase
SELECT TRUE AS "_" FROM myview WHERE 1<>1 LIMIT 0
One of my views takes 13 minutes... yes 13 minutes. Problem is, sync gets auto cancelled after EXACTLY 20 minutes by
deref-with-timeout I'm guessing. So after 20 minutes I get a bunch of these errors and only 4 out of 50 schemas show up in metabase for my redshift connection.
ERROR metabase.driver.redshift Error checking schema permissions com.amazon.redshift.util.RedshiftException: This statement has been closed.
So how do I increase the 20 minute timeout this page is talking about? If there's no config option for it can you point me to where it's hardcoded and I'll just fork?