Hey guys! I am pretty excited about DBT.
I cannot similar questions so bare with me here.
Does incremental function allow update only selected column? For example, I want the update only happens to last_updated_at but not first_received_at column if the unique key match.
Can we skip the update if the unique key shows the record already exit in the table? simple example, my table has user_id and session_id mapping and I only want the new unmapped record to be added in there.