I want to use the condition union if exists with a table referred with {{this}} in snowflake sql
In dbt, i want to append table if exists. Basically, i am building an incremental model where i find out lagged values from previous day, for the first run, i want to union today’s data along with {{this}}, i know that for the first day {{this}} has no values, so i am trying to skip it in the union.