BigQuery - Append missing records from one table to another -

i have 2 tables - 'todays_data' , 'full_data' same schema(id string, name string, age string). records in 'todays_data' may or may not available in 'full_data'. need identify new records(new id) in 'todays_data' , append 'full_data'(id reference key). how achieve using 1)web-ui sql statement , 2)bq command

below query should run full_data table destination table , append table write preference

select id, name, age todays_data not id in (   select id   full_data   group id )   

see more how achieve webui , in commmand line in storing results in permanent table