interface CustomSqlProperty

Language	Type name
.NET	Amazon.CDK.AWS.QuickSight.CfnDataSet.CustomSqlProperty
Go	github.com/aws/aws-cdk-go/awscdk/v2/awsquicksight#CfnDataSet_CustomSqlProperty
Java	software.amazon.awscdk.services.quicksight.CfnDataSet.CustomSqlProperty
Python	aws_cdk.aws_quicksight.CfnDataSet.CustomSqlProperty
TypeScript	aws-cdk-lib » aws_quicksight » CfnDataSet » CustomSqlProperty

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

See also: http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-quicksight-dataset-customsql.html

Example

// The code below shows an example of how to instantiate this type.
// The values are placeholders you should change.
import { aws_quicksight as quicksight } from 'aws-cdk-lib';
const customSqlProperty: quicksight.CfnDataSet.CustomSqlProperty = {
  dataSourceArn: 'dataSourceArn',
  name: 'name',
  sqlQuery: 'sqlQuery',

  // the properties below are optional
  columns: [{
    name: 'name',
    type: 'type',

    // the properties below are optional
    subType: 'subType',
  }],
};

Properties

Name	Type	Description
dataSourceArn	string	The Amazon Resource Name (ARN) of the data source.
name	string	A display name for the SQL query result.
sqlQuery	string	The SQL query.
columns?	IResolvable | (IResolvable | InputColumnProperty)[]	The column schema from the SQL query result set.

---

dataSourceArn

Type: string

The Amazon Resource Name (ARN) of the data source.

See also: http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-quicksight-dataset-customsql.html#cfn-quicksight-dataset-customsql-datasourcearn

---

name

Type: string

A display name for the SQL query result.

See also: http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-quicksight-dataset-customsql.html#cfn-quicksight-dataset-customsql-name

---

sqlQuery

Type: string

The SQL query.

See also: http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-quicksight-dataset-customsql.html#cfn-quicksight-dataset-customsql-sqlquery

---

columns?

Type: IResolvable | (IResolvable | InputColumnProperty)[] (optional)

The column schema from the SQL query result set.

See also: http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-quicksight-dataset-customsql.html#cfn-quicksight-dataset-customsql-columns