Search in book...
Toggle Font Controls
Create new playlist

Name your new playlist

Playlist description (optional)
Sign In

Email address

Password

Forgot Password?

or

Continue with Facebook

Continue with Google
Sign Up

Full Name

Email address

Confirm Email Address

Password

or

Continue with Facebook

Continue with Google

Supported data types

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	`Bigint` `Decimal` `Float` `Int` `Money` `Numeric` `Real` `Smallint` `Smallmoney` `Tinyint`	`Char` `Nchar` `Nvarchar` `Text` `Varchar`	`Date` `Datetime` `Datetime2` `Datetimeoffset` `Smalldatetime`	`bit`
Aurora, MariaDB, and MySQL	`Bigint` `Decimal` `Float` `Int` `Integer` `mediumint` `numeric` `Smallint` `Tinyint`	`Binary` `Blob` `Char` `Enum` `Set` `Text` `Varbinary` `Varchar`	`Date` `Datetime` `Timestamp` `Year`	`Tinyint`
PostgreSQL	`Bigint` `Decimal` `Double` `Integer` `Numeric` `Precision` `Real` `Smallint`	`Char` `Character` `Varchar` `Varying` `character` `Text`	`Date` `Timestamp`	`Boolean`
Athena	`Bigint` `Decimal` `Double` `Integer` `Real` `Smallint` `Tinyint`	`Char` `Varchar`	`Date` `Timestamp`	`Boolean`

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

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.

Table of Contents for Supported data types

Create new playlist

Sign In

Sign Up

Supported data types

Table of Contents for
Supported data types