Appreciate the engagement here. Upon further testing, I've found that it only fails in the new SQL editor environment. It worked when switching to the old SQL editor, and it also worked in a notebook connected to the same serverless computes, as well as non-SQL computes.

@TheOC good suggestion. We tried it on different fields in the same dataset, and it was inconsistent. It failed on a couple and worked on the rest. Furthermore, it seemed to work on other datasets as well but we were not exhaustive in testing. It seems specific to how a field may be configured and also something to do with the new SQL editor environment.

@BS_THE_ANALYST yes I we're on serverless. Just tested again. And also we haven't set up any other compute haha.