Case Statements in Batch spec

I’m trying to collapse a few columns into one column during ingest. Specifically, trying to convert a bunch of bool columns into a single dimension:

case when column1 = true then ‘Value 1’

when column2 = true then ‘Value 2’

else ‘Value 3’

end as newDimColumn

Is there a way to specify this in the batch spec?


I think you may be able to do this with an undocumented 0.12.0 feature: