AWS::QuickSight::DataSet CustomSql - Amazon CloudFormation
SyntaxProperties
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

AWS::QuickSight::DataSet CustomSql

A physical table type built from the results of the custom SQL query.

Syntax

To declare this entity in your Amazon 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: Yes

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

Update requires: No interruption