QuickSight supports the following primitive data types: date, float, integer, and string. If you load data from files and/or databases that contain fields that cannot be implicitly converted to the preceding primitive data types, ensure that they are explicitly converted before they are imported to QuickSight. The following table lists the source data types for specific database engines:
Database type |
Numeric data types |
String data types |
Date-time data types |
Boolean data types |
SQL Server |
|
|
|
|
Aurora, MariaDB, and MySQL |
|
|
|
|
PostgreSQL |
|
|
|
|
Athena |
|
|
|
|
The Datetime
field should be in one of the following formats, which are based on the Joda project class DateTimeFormat
(http://www.joda.org/joda-time/apidocs/org/joda/time/format/DateTimeFormat.html):
yyyy-MM-dd
, for example, 2016-10-01
yyyy-MM-ddTHH
, for example, 2016-10-01T16
yyyy-MM-ddTHH:mm
, for example, 2016-10-01T16:08
yyyy-MM-ddTHH:mm:ss
, for example, 2016-10-01T16:08:29
yyyy-MM-ddTHH:mm:ss.SSS
, for example, 2016-10-01T16:08:29.322
yyyy-MM-ddTHH:mm:ss,SSS
, for example, 2016-10-01T16:08:29, 322
yyyy-MM
, for example, 2016-10
yyyy-MM-ddTHH:mm:ss.SSSZZ
, for example, 2016-10-01T16:08:29.322-08:00
yyyy-MM-ddTHH:mm:ss,SSSZZ
, for example, 2016-10-01T16:08:29,322-08:00
yyyy-MM-ddTHH:mm:ssZZ
, for example, 2016-10-01T16:08:29-08:00
yyyy-DDD
, for example, 2016-066
yyyy-DDDTHH:mm:ss.SSSZZ
, for example, 2016-066T16:08:29.322-08:00
yyyy-DDDTHH:mm:ssZZ
, for example, 2016-066T16:08:29-08:00
yyyy-MM-dd HH:mm:ss.SSS
, for example, 2016-10-01 16:08:29,322
yyyy-MM-dd HH:mm:ss
, for example, 2016-10-01 16:08:29
yyyyMMdd
, for example, 20161001
yyyyMMddTHHmmss.SSSZ
, for example, 20161001T160829.322-0800
yyyyMMddTHHmmssZ
, for example, 20161001T160829-0800
yyyyDDD
, for example, 2016066
yyyyDDDTHHmmss.SSSZ
, for example, 2016066T160829.322-0800
yyyyDDDTHHmmssZ
, for example, 2016066T160829-0800
yyyy
, for example, 2016
yyyy/MM/dd HH:mm:ss
, for example, 2016/10/01 16:08:29
yyyy/MM/dd
, for example, 2016/10/01
MM/dd/yyyy
, for example, 10/01/2016
MM/dd/yy
, for example, 10/01/15
M/d/yyyy
, for example, 1/1/2016
M/d/yy
, for example, 1/1/15
MM/dd/yyyy HH:mm:ss
, for example, 10/01/2016 16:08:29
MM/dd/yy h:mm a
, for example, 10/01/15 4:08 PM
MM/dd/yy HH:mm:ss
, for example, 10/01/15 16:08:29
MM/dd/yy HH:mm
, for example, 10/01/15 16:08
MM/dd/yy hh:mm a
, for example, 10/01/15 04:08 PM
MMM dd
, for example, Oct 01
MMM dd yyyy HH:mm:ss
, for example, Oct 01 2016 16:08:29