Thanks @Tof_Jossic  for your response.

Hi @Pareek1 , below is the query i used and it worked.  INSERT INTO dataset_name SELECT struct(customerid, first_name, lastname, email ) AS _spnam from(select 1 AS customerid, _spnam.first_name as first_name, _spnam.lastname as lastname, struct(_spnam.email.address as address) as email from dataset ...

While using update statement in query service getting the below error before the dataset, Please could anyone have solution? What is MODEL here?  ErrorCode: 42601 queryId: 9fad4729-3cf8-4832-ba50-65763ca26fd8 Syntax error encountered. Reason: [line 1:8: missing 'MODEL'