A scheduled task that references data from the database is failing with errors such as:
“Statement reached its statement or warehouse timeout of 600 second(s) and was canceled.”
To address this issue, consider reviewing and optimizing the SQL statement. Below are some suggestions for improvement:
- Select only the necessary columns: Avoid selecting unnecessary columns to reduce the query’s processing time and data volume.
- Break down the query: Split the query into smaller, more manageable datasets, and then join them later within Exploratory.
These steps can help reduce the query’s complexity and improve performance.