CONVERT_TO(OptIn, ‘BOOLEAN’) AS OptIn
This does not work.
CONVERT_TO does not support conversion to type ‘BOOLEAN’.
https://docs.dremio.com/sql-reference/data-types.html?h=boolean
https://docs.dremio.com/sql-reference/sql-functions/type-conversion.html?h=conversion