CASE

This function isn’t in the updated function reference yet. The details below come from the previous docs, and the product team is confirming them.

Syntax

CASE Returns the result of the first condition evaluating to true or returns the default value if all conditions evaluate to false.

SYNTAX - CASE
             WHEN condition1 THEN result1
             [WHEN condition2 THEN result2 ]
             [WHEN ......]
             [ELSE default ]
         END

> select col1,
               case
                    when col1 < 0 then 'res1'
                    when col1 > 0 then 'res2'
                    else 'res3'
               end as result
           from table

Last modified on November 3, 2026

Query Engine

Get started

Connect data

Run clusters

Query

Connect your tools

Secure and govern

Troubleshoot

Reference

Concepts

Syntax

​Syntax

Syntax