AWS::QuickSight::DataSet CustomSql
A physical table type built from the results of the custom SQL query.
Syntax
To declare this entity in your AWS CloudFormation template, use the following syntax:
JSON
{ "Columns" :
[ InputColumn, ... ]
, "DataSourceArn" :String
, "Name" :String
, "SqlQuery" :String
}
YAML
Columns:
- InputColumn
DataSourceArn:String
Name:String
SqlQuery:String
Properties
Columns
-
The column schema from the SQL query result set.
Required: No
Type: Array of InputColumn
Minimum:
1
Maximum:
2048
Update requires: No interruption
DataSourceArn
-
The Amazon Resource Name (ARN) of the data source.
Required: Yes
Type: String
Update requires: No interruption
Name
-
A display name for the SQL query result.
Required: Yes
Type: String
Minimum:
1
Maximum:
128
Update requires: No interruption
SqlQuery
-
The SQL query.
Required: Yes
Type: String
Minimum:
1
Maximum:
168000
Update requires: No interruption