Forum Discussion

darshthakkar's avatar
darshthakkar
Valued Contributor
3 years ago
Solved

Reading data from an empty table in snowflake

How can we read an empty table from Snowflake - Select snap? While I use Snowflake - Select snap and the table is empty, I don’t see any output preview so I decided to write it down to a flat fil...
  • del's avatar
    4 years ago

    Hi @rpathak,

    For your update snap, you will need to include a record identifier condition in the Update Condition field. Otherwise, for every input record, it updates all the records in the table matching the UPDTD_TS>=getdate()-2 condition.

    So you might change your current Update Condition to something like:
    COUPON_ID = $COUPON_ID and UPDTD_TS>=getdate()-2