Hello @hoyeon
Thank you for the follow up questions.
Timeout: QuickSight enforces a 2-minute timeout for visual generation. If the Direct Query exceeds this time, the visual may fail to load.
I would suggest you to have a look on these blogs, they are really very insightful and provides the required answers.
- Best practices for Amazon QuickSight SPICE and direct query mode
- SPICE and Direct Queries for Enhanced Data Analytics and Visualization
- Joining across data sources on Amazon QuickSight | AWS Big Data Blog
Let me know if these helps.
Thank you,
Shravya