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