interface CustomSqlProperty
| Language | Type name |
|---|---|
.NET | Amazon.CDK.Mixins.Preview.AWS.QuickSight.Mixins.CfnDataSetPropsMixin.CustomSqlProperty |
Go | github.com/aws/aws-cdk-go/awscdkmixinspreview/v2/awsquicksight/mixins#CfnDataSetPropsMixin_CustomSqlProperty |
Java | software.amazon.awscdk.mixins.preview.services.quicksight.mixins.CfnDataSetPropsMixin.CustomSqlProperty |
Python | aws_cdk.mixins_preview.aws_quicksight.mixins.CfnDataSetPropsMixin.CustomSqlProperty |
TypeScript | @aws-cdk/mixins-preview » aws_quicksight » mixins » 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 { mixins as quicksight_mixins } from '@aws-cdk/mixins-preview/aws-quicksight';
const customSqlProperty: quicksight_mixins.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