Amazon QuickSight – Data Types from Other Sources
QuickSight supports a variety of data sources, including Amazon Athena, Presto, Amazon Aurora, MariaDB, MySQL, Amazon OpenSearch Service, Oracle, PostgreSQL, Apache Spark, Snowflake, and Microsoft SQL Server. Each of these sources has its own set of data types, and QuickSight is able to handle and visualize data from these sources in a unified manner. By understanding the data types of each source, users can ensure that their data is accurately represented in QuickSight visualizations.
Data types supported by Other Sources available in Amazon QuickSight are listed in the following table.
| Database engine or source | Numeric data types | String data types | Datetime data types | Boolean data types |
| Amazon Athena Presto | 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 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 |