Unable to cast data types programmatically

I am creating a data set thru the API. I am casting columns from an Athena query to a correct data type.

When I call describe-data-set, I do see the column types ("Type": "INTEGER") are set in the CustomSql.Columns array and the OutputColumns array.

I am able to do a SPICE refresh without a problem.

Yet, when I look at the data set in the UI, all the preview column types are set to STRING.

I tried to completely delete the data set and create it again, and I got the same result.

How can a column type be specified during the data set creation or an update operation thru the API?


Can you paste in the json you are using to create the data set?

Was my fault, nothing to do with QS. Closing :slight_smile: