AWS Quicksight – Data Source Limit

In this guide, we will discuss Data Source Limit in AWS Quicksight. 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 IDSales DateAmount
00110/14/201712.43
0025/3/201725.00
003Unknown18.17
0043/8/201986.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 SourceNumber Data TypesString Data TypesDate time Data TypesBoolean Data Types
Amazon Athena,PrestobigintdecimaldoubleintegerrealsmallinttinyintcharvarchardatetimestampBoolean
Amazon Aurora, MariaDB,and MySQLbigintdecimaldoubleintintegermediumintnumericsmallinttinyintcharenumsettextvarchardatedatetimetimestampyear
PostgreSQLbigintdecimaldoubleintegernumericprecisionrealsmallintcharcharactertextvarcharvarying characterdatetimestampBoolean
Apache SparkbigintdecimaldoubleintegerrealsmallinttinyintvarchardatetimestampBoolean
Snowflakebigintbyteintdecimaldoubledoubleprecisionfloatfloat4float8intintegernumbernumericrealsmallinttinyintcharcharacterstringtextvarchardatedatetimetimetimestamptimestamp_*Boolean
Microsoft SQL Serverbigintbitdecimalintmoneynumericrealsmallintsmallmoneytinyintcharncharnvarchartextvarchardatedatetimedatetime2datetimeoffsetsmalldatetimebit

Next Topic : Click Here

Leave a Reply