Troubleshooting QuickSight: DynamoDB 'List' Data Type Import Issue Detailed Description: In the process of creating reports in QuickSight, we have encountered an issue specific to importing

Detailed Description: In the process of creating reports in QuickSight, we have encountered an issue specific to importing data from our DynamoDB source. There is a particular column with a data type of 'List' that is consistently removing in the QuickSight dataset after import. This behaviour suggests that QuickSight does not handle 'List' data types from DynamoDB during the data import process. Impact: The data within this 'List' column is critical for our reporting and analytics. The inability to include this column in our QuickSight reports is severely limiting the insights we can provide to our stakeholders, and as such, is impacting our business analysis capabilities. Troubleshooting Already Performed: • Verified the integrity and accessibility of the data within DynamoDB. • Checked for any QuickSight documentation regarding limitations with 'List' data types from DynamoDB (no clear documentation found). • Attempted to re-import the data and recreate the data source within QuickSight. • Searched for similar issues or solutions in the AWS forums and QuickSight user community. Request: We need guidance on how to successfully import columns with 'List' data types from DynamoDB into QuickSight, or a workaround to ensure that this data is not skipped. If this is a limitation within QuickSight, we would appreciate advice on best practices for handling such data types for reporting purposes. Urgency and Severity: This issue is critical as it is hindering our ability to perform complete data analysis. We require urgent support to resolve this import problem to maintain our reporting and business intelligence operations. Note: We can not change the data type in DynamoDB from “List” to “Map”.