I tried to use direct query mode to import data into Amazon QuickSight, but I get a query timeout error.
Short description
The following are common reasons for timeout errors when you use direct query mode to import data into QuickSight:
- Data preparation takes more than 45 seconds.
- Generating a visual takes more than 2 minutes.
- The query runtime exceeds the data source timeout quota for the AWS service that you imported from. To see the data source timeout quota for your web service, see AWS service quotas.
Note: You can't increase the 2-minute visual generation timeout quota.
Resolution
Limit the data that you're importing
The following are actions that you can take to limit the amount of data that you imported into QuickSight:
- Unselect columns that you don't need.
- Add filters to your dataset in QuickSight.
- Use predicates in your custom SQL query, such as WHERE and HAVING.
Import the data into SPICE
When you import your data into SPICE, queries process faster. If you still receive query timeout errors, then see How do I resolve "query timeout" errors when I import data from Athena to QuickSight SPICE?
Note: The 45-second timeout quota for data preparation and 2-minute timeout to generate visuals still apply when you use SPICE. However, if you use Amazon Athena to import data into QuickSight, then the query timeout is 30 minutes.
For more information about SPICE quotas for imported data and quotas for direct SQL queries, see Data source quotas.