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

Get Effective Business Intelligence with QuickSight now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.