AWS::QuickSight::DataSet CustomSql - AWS CloudFormation
SyntaxProperties
Services or capabilities described in AWS documentation might vary by Region. To see the differences applicable to the AWS European Sovereign Cloud Region, see the AWS European Sovereign Cloud User Guide.

This is the new 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 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: 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