Below is an example showing use of Geocode operation in Snowflake
environment:
create or replace table all_data_result as
select ID,addressline1,city,state,zip,
object_construct(
'addressId', iff(ID is not null, ID,'')
,'addressLines', array_construct(iff(ADDRESSLINE1 is not null, ADDRESSLINE1,''))
,'country',country
,'city',iff(city is not null, city,'')
,'admin1',iff(state is not null, state,'')
,'postalCode',iff(zip is not null, zip,'')
) as sentObject
, geocode(sentObject) as address,country from all_data;