@vkt1989 What about something like this:
select struct( 'NY' as city) "_Tenant.ProfileAttributes.address", struct('VP' as role) "_Tenant.ProfileAttributes", struct('123' as customerID) "_Tenant"
OR
select struct( 'NY' as city) "_Tenant.ProfileAttributes.address.city", struct('VP' as role) "_Tenant...