How do I resolve query timeout errors in QuickSight?

2 minute read
1

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.

AWS OFFICIAL
AWS OFFICIALUpdated 8 months ago