Supported data types from other data sources - Amazon QuickSight

Important: We've redesigned the Amazon QuickSight analysis workspace. You might encounter screenshots or procedural text that doesn't reflect the new look in the QuickSight console. We're in the process of updating screenshots and procedural text.

To find a feature or item, use the Quick search bar.

For more information on QuickSight's new look, see Introducing new analysis experience on Amazon QuickSight.

Supported data types from other 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