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”.
