That is peculiar but not altogether surprising, to generate the DDL it needs everything, to query maybe doesn't need whatever is missing. I would create a similar table with Athena or the console and compare what are you missing in CDK, depends a lot on the kind of table
I don't think it is related with CDK but with the table definition being invalid (missing something)
But the table works well. I can do SELECT / INSERT etc.
That is peculiar but not altogether surprising, to generate the DDL it needs everything, to query maybe doesn't need whatever is missing. I would create a similar table with Athena or the console and compare what are you missing in CDK, depends a lot on the kind of table