Help with Snowflake Query in Workflows

Hey!

Running into a confusing problem here. So I've written a query of the form:

Select * from table1 left join table2 where table2.status is null (Line 32 of the screenshot).

I am still seeing non-null values in the data that gets pulled. Tried everything from equating it to an empty string or using EQUAL_NULL. Same result.

Anyone face a similar issue?

Hi @Haseeb1399 Thanks for reaching out! :thinking: Do you see the same results in an app query? Curious if you've tested this query outside of Retool for comparison?

I wasn't able to reproduce an issue here, but I'd recommend removing the other parts of the where clause and then adding them back one by one to see if there is a point that causes unexpected results