AWS Quicksight - Data Source Limit

When you use different data sources in Quicksight tool, there are certain limits that apply based on data sources.

File

You can use up to 25GB of total size specified in manifest file. This limit is dependent on the file size after it is imported to SPICE.

The number of files supported in manifest file is 1000 and you also have some limit on number of columns in each file.

Table and Query

When you are querying a large table, it is recommended that you use Where or Having condition to reduce the number of data imported to SPICE. Query result imported into SPICE should not exceed 25 GB.

You can deselect some of the columns while importing the data into SPICE.

In case your data source contains data type which are not supported in Quicksight, AWS Quicksight skips those values.

Person ID	Sales Date	Amount
001	10/14/2017	12.43
002	5/3/2017	25.00
003	Unknown	18.17
004	3/8/2019	86.02

From the above values, Quicksight will drop the no date value row while importing this data in dataset. Following data types are supported in Quicksight −

Database Source	Number Data Types	String Data Types	Date time 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
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 datetimeoffset smalldatetime	bit

Print Page