# Auto-detect 'column' fields in Quicksight CDK API?

**URL:** <https://community.amazonquick.com/t/auto-detect-column-fields-in-quicksight-cdk-api/49474>\
**Category:** Q&A\
**Tags:** SDK, feature-request, developer, quick-sight\
**Created:** [August 27, 2025, 6:35pm UTC](https://community.amazonquick.com/t/auto-detect-column-fields-in-quicksight-cdk-api/49474 "2025-08-27T18:35:19Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![cinzy](https://avatars.discourse-cdn.com/v4/letter/c/5e9695/32.png) [@cinzy](https://community.amazonquick.com/u/cinzy)\
**Post date:** [August 27, 2025, 6:35pm UTC](https://community.amazonquick.com/t/auto-detect-column-fields-in-quicksight-cdk-api/49474/1 "2025-08-27T18:35:19Z")

</div>

Using the quicksight dashboard UI, I can always create a new DataSet in my dashboard, and the DataSet will automatically show me all the columns in it. However, using the CDK, it seems that column is a required field. Is there a way to auto-detect the column names?

The SDK documentation for CDK function doesn’t seem to describe how to ignore ‘column’: [CfnDataSet — AWS Cloud Development Kit 2.213.0 documentation](https://docs.aws.amazon.com/cdk/api/v2/python/aws_cdk.aws_quicksight/CfnDataSet.html#cfndataset)

```auto

new quicksight.CfnDataSet(this, dataSetName, {
      awsAccountId: this.account,
      dataSetId: dataSetName,
      name: dataSetName,
      importMode: 'DIRECT_QUERY',
      physicalTableMap: {
        physicalMapId: {
          customSql: {
            dataSourceArn: dataSourceArn,
            name: queryName,
            columns: [
              { name: 'need_to_manually_define_each_column_for_each_table' type: 'STRING' },
            ],
            sqlQuery: `SELECT * FROM 'database'.'table'`,
          },
        },
      },
      datasetParameters: [
        {
          stringDatasetParameter: {
            id: 'xxx',
            name: 'xxx',
            valueType: 'SINGLE_VALUED',
            defaultValues: {
              staticValues: ['null'],
            },
          },
        },
      ],
      permissions: xxxxxxx
    });

```

---

<div class="post-metadata">

**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\
**Post date:** [August 29, 2025, 2:23pm UTC](https://community.amazonquick.com/t/auto-detect-column-fields-in-quicksight-cdk-api/49474/2 "2025-08-29T14:23:25Z")

</div>

Hi @cinzy and welcome to the Quick Sight community!

Currently, I do not believe there’s a way to auto-detect the column names when using the CDK. I will mark this as a feature request to promote visibility to the support team.

Thank you

---

<div class="post-metadata">

**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\
**Post date:** [September 8, 2025, 4:12pm UTC](https://community.amazonquick.com/t/auto-detect-column-fields-in-quicksight-cdk-api/49474/3 "2025-09-08T16:12:27Z")

</div>

Hi @cinzy,

While I’ve marked this as a feature request already, following up here to see if you had any additional questions or comments to add?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

---

<div class="post-metadata">

**Author:** ![cinzy](https://avatars.discourse-cdn.com/v4/letter/c/5e9695/32.png) [@cinzy](https://community.amazonquick.com/u/cinzy)\
**Post date:** [September 9, 2025, 8:09pm UTC](https://community.amazonquick.com/t/auto-detect-column-fields-in-quicksight-cdk-api/49474/4 "2025-09-09T20:09:53Z")

</div>

Let me know how I can track the updates, so if the feature does get prioritized I would like to use it on the next available version

---

<div class="post-metadata">

**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\
**Post date:** [September 11, 2025, 5:04pm UTC](https://community.amazonquick.com/t/auto-detect-column-fields-in-quicksight-cdk-api/49474/5 "2025-09-11T17:04:15Z")

</div>

Hi @cinzy,

While Quick Sight does not provide information or timetables on their current roadmap, you can follow the [‘What’s New’ section](https://community.amazonquick.com/c/announcements/12/none) in the community for all new updates that are made.