Quick Suite Dataset from Athena not able to use "Directly query your data"

When setting up Amazon QuickSight to connect to Athena data sources, there are a few reasons why your selection of "Directly query your data" might not be working as expected.

First, it's important to verify that you're following the correct workflow. When creating a dataset from Athena in QuickSight, you should:

1. Open the QuickSight console
2. Choose "Datasets" and then "New dataset"
3. Select Athena as your data source
4. Choose the database containing your view or table
5. Select the specific view you want to use
6. On the "Finish data set creation" page, select "Directly query your data"
7. Choose "Visualize"

If you're following these steps but still encountering issues, there could be several potential causes:

1. There might be configuration settings at the dataset level that are preventing direct query. Check if there are any DataSetUsageConfiguration settings that have DisableUseAsDirectQuerySource enabled.

2. You might be hitting performance limitations. QuickSight often defaults to SPICE (QuickSight's in-memory calculation engine) because direct queries to Athena can be slower for complex data or large datasets.

3. There could be compatibility issues with your specific Athena query or data types. Some complex queries or certain data types in Athena might not be fully compatible with QuickSight's direct query mode.

4. If you're using the Enterprise edition of QuickSight, you might want to consider using incremental refreshes (available as frequently as every 15 minutes) as an alternative to direct querying if real-time data is your goal.

If the issue persists, you may need to contact AWS Support for further assistance, as this could be related to specific limitations or configurations in your QuickSight environment.
Sources
Analyze and visualize nested JSON data with Amazon Athena and Amazon QuickSight - AWS Prescriptive Guidance
DataSetUsageConfiguration - Amazon Quick Sight
Real Time Data Ingestion | AWS re:Post