You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Add clause/function to exclude columns during whenMatchedUpdate
Use Case
In a table with 100+ columns during update we've to manually specify in update condition to input all required columns rather excluding one or two. Eg: CREATE_TS need not be updated during update.
Expected functionality is as below
UPDATE SET * EXCLUDE(CREATE_TS)
Related Issue(s)
The text was updated successfully, but these errors were encountered:
Description
Add clause/function to exclude columns during whenMatchedUpdate
Use Case
In a table with 100+ columns during update we've to manually specify in update condition to input all required columns rather excluding one or two. Eg: CREATE_TS need not be updated during update.
Expected functionality is as below
UPDATE SET * EXCLUDE(CREATE_TS)
Related Issue(s)
The text was updated successfully, but these errors were encountered: