Invalid data when using Athena with Amazon QuickSight - Amazon QuickSight

Important: We've redesigned the Amazon QuickSight analysis workspace. You might encounter screenshots or procedural text that doesn't reflect the new look in the QuickSight console. We're in the process of updating screenshots and procedural text.

To find a feature or item, use the Quick search bar.

For more information on QuickSight's new look, see Introducing new analysis experience on Amazon QuickSight.

Invalid data when using Athena with Amazon QuickSight

An invalid data error can occur when you use any operator or function in a calculated field. To address this, verify that the data in the table is consistent with the format that you supplied to the function.

For example, suppose that you are using the function parseDate(expression, [‘format’], [‘time_zone’]) as parseDate(date_column, ‘MM/dd/yyyy’). In this case, all values in date_column must conform to 'MM/dd/yyyy' format (’05/12/2016’). Any value that isn't in this format (‘2016/12/05’) can cause an error.