I am trying to run query on metabase and it's taking long time to run.. and am getting the following error
"your question took too long ".
we are using Redshift as a data source (4 node cluster)
Kindly help on how to fix this error?

Hi @ssd
What is the definition of "it's taking long time to run" ?
Sounds like you might have a reverse-proxy closing the connection too early.
Post "Diagnostic Info" from Admin > Troubleshooting, and how+where you're hosting Metabase.