Aws Quicksight 简明教程
AWS Quicksight - Data Source Limit
当您在 Quicksight 工具中使用不同的数据源时，会根据数据源应用某些限制。
When you use different data sources in Quicksight tool, there are certain limits that apply based on data sources.
File
您最多可以使用清单文件中指定的大小 25 GB。此限制取决于导入到 SPICE 后的大小。
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.
清单文件中支持的文件数量为 1000，并且对每个文件中的列数也有一些限制。
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
当您查询一个大表时，建议您使用 Where 或 Having 条件来减少导入到 SPICE 的数据数量。导入到 SPICE 中的查询结果不应超过 25 GB。
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.
您可以在将数据导入 SPICE 时取消选择一些列。
You can deselect some of the columns while importing the data into SPICE.
如果您的数据源包含 Quicksight 不支持的数据类型，AWS Quicksight 会跳过这些值。
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 |
从以上值来看，在数据集导入这些数据时，Quicksight 将删除无日期值所在行。Quicksight 中支持以下数据类型-
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 |
bigintdecimaldoubleintegerrealsmallinttinyint |
charvarchar |
datetimestamp |
Boolean |
Amazon Aurora, MariaDB,and MySQL |
bigintdecimaldoubleintintegermediumintnumericsmallinttinyint |
charenumsettextvarchar |
datedatetimetimestampyear |
|
PostgreSQL |
bigintdecimaldoubleintegernumericprecisionrealsmallint |
charcharactertextvarcharvarying character |
datetimestamp |
Boolean |
Apache Spark |
bigintdecimaldoubleintegerrealsmallinttinyint |
varchar |
datetimestamp |
Boolean |
Snowflake |
bigintbyteintdecimaldoubledoubleprecisionfloatfloat4float8intintegernumbernumericrealsmallinttinyint |
charcharacterstringtextvarchar |
datedatetimetimetimestamptimestamp_* |
Boolean |
Microsoft SQL Server |
bigintbitdecimalintmoneynumericrealsmallintsmallmoneytinyint |
charncharnvarchartextvarchar |
datedatetimedatetime2datetimeoffsetsmalldatetime |
bit |