AWS::QuickSight::DataSet CustomSql - AWS CloudFormation
SyntaxProperties

This is the new AWS CloudFormation Template Reference Guide. Please update your bookmarks and links. For help getting started with CloudFormation, see the AWS CloudFormation User Guide.

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: 0

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