Use of SQL functions

[nzscripps]

Using SQL functions is not working with this and using the Snowflake Native Driver. We have a number of queries like:

select *, case when run_code = 'Y' then 'Aired'
when run_code = 'N' and intended_air_date < current_date() then 'No Run'
when run_code = 'N' and intended_air_date >= current_date() then 'Scheduled'
else 'NA' end as Status
from MY_SNOWFLAKE_TABLE 

The query is not parsed correctly. Simple queries like:

SELECT ID, NAME from MY_SNOWFLAKE_TABLE

Work fine. Any ideas as to why functions don't get parsed?

[yoramdelangen]

Do you have a bit more information (error, expected results/query)?

[mckaygerhard]

the first query need a more elaborate way, by example using subquery or aliasing.. @nzscripps

[yoramdelangen]

@nzscripps do you have a error thats being given?