We have an enterprise QS account that has occupied ~13TB SPICE capacity. We found 500+ datasets on SPICE that are not updated in last 180 days. To make best use of SPICE, we decided to update the inactive datasets from SPICE to DIRECT_QUERY.
When we tried to programmatically update the datasets ImportMode from SPICE to DIRECT_QUERY. We are getting below error and are unable to proceed further. Can you please help us in getting unblocked.
botocore.errorfactory.InvalidParameterValueException: An error occurred (InvalidParameterValueException) when calling the UpdateDataSet operation: Only SPICE dataset can have sub-type.