AWS Quicksight Tutorial
Selected Reading
- AWS Quicksight - Discussion
- AWS Quicksight - Useful Resources
- AWS Quicksight - Quick Guide
- Developer Responsibilities
- AWS Quicksight - AWS SDKs
- AWS Quicksight - Embedding Dashboard
- AWS Quicksight - Managing IAM Policies
- AWS Quicksight - Edition Type
- AWS Quicksight - Managing Quicksight
- AWS Quicksight - Dashboards
- AWS Quicksight - Sharing Analysis
- AWS Quicksight - Using Parameters
- AWS Quicksight - Creating Story
- AWS Quicksight - Insights
- Using Filters to a Visual
- AWS Quicksight - Adding Visuals
- AWS Quicksight - Creating New Analysis
- AWS Quicksight - Editing Datasets
- AWS Quicksight - Data Source Limit
- AWS Quicksight - Using Data Sources
- AWS Quicksight - Landing Page
- AWS Quicksight - Overview
- AWS Quicksight - Home
Selected Reading
- Who is Who
- Computer Glossary
- HR Interview Questions
- Effective Resume Writing
- Questions and Answers
- UPSC IAS Exams Notes
AWS Quicksight - Data Source Limit
AWS Quicksight - Data Source Limit
When you use different data sources in Quicksight tool, there are certain pmits that apply based on data sources.
File
You can use up to 25GB of total size specified in manifest file. This pmit 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 pmit 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 smalpnt tinyint |
char varchar |
date timestamp |
Boolean |
| Amazon Aurora, MariaDB,and MySQL |
bigint decimal double int integer mediumint numeric smalpnt tinyint |
char enum set text varchar |
date datetime timestamp year |
|
| PostgreSQL |
bigint decimal double integer numeric precision real smalpnt |
char character text varchar varying character |
date timestamp |
Boolean |
| Apache Spark |
bigint decimal double integer real smalpnt tinyint |
varchar |
date timestamp |
Boolean |
| Snowflake |
bigint byteint decimal double doubleprecision float float4 float8 int integer number numeric real smalpnt tinyint |
char character string text varchar |
date datetime time timestamp timestamp_* |
Boolean |
| Microsoft SQL Server |
bigint bit decimal int money numeric real smalpnt smallmoney tinyint |
char nchar nvarchar text varchar |
date datetime datetime2 datetimeoffset smalldatetime |
bit |