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