Hello Community,
I have a interesting challenge but I don’t exactly know if this is possible.
I want to make a batch update of old datasets and switch them back from Spice to Direct Query to save some Spice Space.
Is there a Boto option (or any other option) to change the dataset settings?
Greetings
Felix
Hi @Felix_Krall
you could try to change the ImportMode='SPICE'|'DIRECT_QUERY'not sure it will work, but it is worth a try.
BR
Hi @ErikG ,
thanks for the idea.
I tried this in the “Update Data Set” Request.
But this request only tries to update the underlying data but not the logic. Which generates the following error.
InvalidParameterValueException: An error occurred (InvalidParameterValueException) when calling the UpdateDataSet operation: Only SPICE dataset can have sub-type.
Greetings
Felix
