Unable to cast data types programmatically

Question & Answer
1

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?

Thanks.

2

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

3

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