o am trying tô update a field that is structure type but o have This error:
Update set does not support array modification with []
I tryed This sql code in big query:
“`updatemytablelocation set event_params[SAFE_OFFSET(0)].value.string_value = SHA256( event_params[SAFE_OFFSET(0)].value.string_value) where event_name = ‘purchase’ and event_params[SAFE_OFFSET(0)].key = ’email’
To transform an email value tô hash sha256
New contributor
LAURA CECíLIA is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.