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.
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 = {
columns: [{
name: 'name',
type: 'type',
// the properties below are optional
subType: 'subType',
}],
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
[]
The column schema from the SQL query result set.
dataSourceArn
Type:
string
The Amazon Resource Name (ARN) of the data source.
name
Type:
string
A display name for the SQL query result.
sqlQuery
Type:
string
The SQL query.