darshthakkar
3 years agoValued Contributor
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...
- 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