How do I resolve "query timeout" errors when I import data from Athena to QuickSight SPICE?

Resolution

This error occurs because the DML query reached its maximum runtime. To resolve this error, increase the query runtime. You can also reduce the time to run the query from Athena.

Increase the query runtime for Amazon Athena

Complete the following steps:

1. Check your recent Athena queries to find the query that QuickSight generated.
2. Note how long the query ran before it failed.
3. If the amount of time is close to the maximum DML query timeout quota (in minutes), then increase the service quota.

For more information on AWS service quotas and to request a quota increase, see AWS service quotas.

Reduce the amount of time to run the query from Athena

To reduce the query runtime, take the following actions:

• Use partition projection to divide your table into parts and keep the related data together.
• Compress files, or split them if you can. For more information on supported compression formats, see Athena compression support.
• Optimize the size of your files.

For more information, see How can I resolve "Query Timeout" errors in Athena?

Related information

Top 10 performance tuning tips for Amazon Athena