Need to identify which all fields got updated post transform

SNOW46
Tera Contributor

Hello All,

We are receiving a weekly report for all active users records from AD Team. I am trying to import that sheet in SNOW via Import Set and perform the mapping of the fields making User ID unique or coalesce and performing the transform for all those records in the sys_user table.

Here I need to identify post the transform for all the records which all fields got updated? I can see the updates count as 1 for each record but can't able to figure out which all fields got updated.

Can someone help me out on this acivity? I need to prepare a demo fr our management on this.

 

Thanks

6 REPLIES 6

SNOW46
Tera Contributor

Hello Saini,

Its a gentle reminder from my side.

Can you please help me with the detailed script to achieve this?

I have got stuck here, need your help as I need to showcase a demo for this.

 

Thanks

SNOW46
Tera Contributor

Hello Saini,

Its a gentle reminder from my side.

Can you please help me with the detailed script to achieve this?

I have got stuck here, need your help as I need to showcase a demo for this.

 

Thanks