@emilyzhu I posted about it here, but TLDR it is as follows:
- Dataset that was automatically updating with no issues for a long time got stuck in a refresh
- Duplicating dataset reproduced error
- Copy/pasting SQL worked fine
- Error being thrown referenced a datetime column being in the wrong format
- After individually removing calculated fields, found that any field doing any division of any kind (none of mine were using a datetime column, curiously) would cause the entire dataset to fail to update and caused all dashboards to not work
I have tested this on other non-production datasets and reproduced this error by creating a calculated field in the data prep stage with 1/2 (or any math you like) as the formula. My calculated columns were int/int.