[Amazon](500310] SQL reparse error

[Biswajit_1993]

Hi @makotong,

First of all, welcome to the QuickSight Community!

As per my understanding, this error occurs when there is an issue with the datatype parsing in your query.

Please check this link for further assistance with your problem

Quicksight can not parse Date from dataset

Hi Community! I am a new user of Quicksight. I use it to visualize my dynamoDB data with Athena Connector. I have LatestDate field which is initially a string and 99.99% of rows have format yyyy-MM-dd'T'HH:mm:ss.SSSSSS+SS:SS. And sometimes there are rows that have yyyy-MM-dd'T'HH:mm:ss+SS:SS format. I don’t mind skipping them, so I just changed the data type for LatestDate to Date with yyyy-MM-dd'T'HH:mm:ss.SSSSSS+SS:SS. And as far as I understand Quicksight will drop invalid rows. But then …

Thanks & Regards
Biswajit Dash