# CustomSqlProperty

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

- Source: Generated code
- Type last changed: v2.224.0 · 13 Nov 2025

## Example

```ts
// 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
    id: 'id',
    subType: 'subType',
  }],
  dataSourceArn: 'dataSourceArn',
  name: 'name',
  sqlQuery: 'sqlQuery',
};
```

## Properties

- `columns`: [IResolvable](/cdk/api/v2/docs/aws-cdk-lib.IResolvable.html) | [IResolvable](/cdk/api/v2/docs/aws-cdk-lib.IResolvable.html) | [CfnDataSet.InputColumnProperty](/cdk/api/v2/docs/aws-cdk-lib.aws_quicksight.CfnDataSet.InputColumnProperty.html)[] (required) — The column schema from the SQL query result set.

- `dataSourceArn`: string (required) — The Amazon Resource Name (ARN) of the data source.

- `name`: string (required) — A display name for the SQL query result.

- `sqlQuery`: string (required) — The SQL query.
