interface CustomSqlProperty
| Language | Type name |
|---|---|
.NET | Amazon.CDK.CfnPropertyMixins.AWS.QuickSight.CfnDataSetPropsMixin.CustomSqlProperty |
Go | github.com/aws/aws-cdk-go/awscdkcfnpropertymixins/v2/awsquicksight#CfnDataSetPropsMixin_CustomSqlProperty |
Java | software.amazon.awscdk.cfnpropertymixins.services.quicksight.CfnDataSetPropsMixin.CustomSqlProperty |
Python | aws_cdk.cfn_property_mixins.aws_quicksight.CfnDataSetPropsMixin.CustomSqlProperty |
TypeScript | @aws-cdk/cfn-property-mixins » aws_quicksight » CfnDataSetPropsMixin » CustomSqlProperty |
A physical table type built from the results of the custom SQL query.
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/cfn-property-mixins';
const customSqlProperty: quicksight.CfnDataSetPropsMixin.CustomSqlProperty = {
columns: [{
id: 'id',
name: 'name',
subType: 'subType',
type: 'type',
}],
dataSourceArn: 'dataSourceArn',
name: 'name',
sqlQuery: 'sqlQuery',
};
Properties
| Name | Type | Description |
|---|---|---|
| columns? | IResolvable | (IResolvable | Input)[] | The column schema from the SQL query result set. |
| data | string | The Amazon Resource Name (ARN) of the data source. |
| name? | string | A display name for the SQL query result. |
| sql | string | The SQL query. |
columns?
Type:
IResolvable | (IResolvable | Input)[]
(optional)
The column schema from the SQL query result set.
dataSourceArn?
Type:
string
(optional)
The Amazon Resource Name (ARN) of the data source.
name?
Type:
string
(optional)
A display name for the SQL query result.
sqlQuery?
Type:
string
(optional)
The SQL query.

.NET
Go
Java
Python
TypeScript