Supported data types from external data sources

The following table lists data types that are supported when using the following data sources with Amazon QuickSight.

Database engine or source	Numeric data types	String data types	Datetime data types	Boolean data types
Amazon Athena, Presto, Starburst, Trino	bigint decimal double integer real smallint tinyint	char varchar	date timestamp	boolean
Amazon Aurora, MariaDB, and MySQL	bigint decimal double int integer mediumint numeric smallint tinyint	char enum set text varchar	date datetime timestamp year
Amazon OpenSearch Service	byte integer long float double	string (keyword string field type in OpenSearch Service) ip	timestamp	boolean binary
Oracle	bigint decimal decimal int money numeric real smallint smallmoney tinyint	char nchar nvarchar text varchar	date datetime datetime2 datetimeoffset smalldatetime	bit
PostgreSQL	bigint decimal double integer numeric precision real smallint	char character text varchar varying character	date timestamp	boolean
Apache Spark	bigint decimal double integer real smallint tinyint	varchar	date timestamp	boolean
Snowflake	bigint byteint decimal double doubleprecision float float4 float8 int integer number numeric real smallint tinyint	char character string text varchar	date datetime time timestamp timestamp_*	boolean
Microsoft SQL Server	bigint bit decimal int money numeric real smallint smallmoney tinyint	char nchar nvarchar text varchar	date datetime datetime2 smalldatetime	bit

Warning Javascript is disabled or is unavailable in your browser.

To use the Amazon Web Services Documentation, Javascript must be enabled. Please refer to your browser's Help pages for instructions.

Supported data types and values

Supported date formats