Create AWS Quicksight Dataset using CDK

Given that CDK renders a static (declarative) CloudFormation template, there is no native way for it to infer any information that it doesn't have at the time of synthesis.

A workaround might be using a CustomResource to fetch this information from Glue and then pass it to the CfnDataSet, but not sure if that'd work, given that data set definitions (data types) and Glue data type may not map directly. So you'd have to implement your custom resource logic and then to also do this remapping to convert the return value to DataSet specific way of declaring the data types.

Overall, I do not recommend this approach. I think it's better to have your code be the source of truth, which then declares both Glue and QS DataSet definitions from one place.