BigQuery SQL, append SQL query result to existing table

Question

I'm using Google Cloud Platform BigQuery SQL.

I have a table [myTable] and I'm writing the following SQL. I want to append the result of this SQL to myTable, but all I have managed so far is to replace myTable every time I run the SQL.

Can someone tell me what is the SQL sentence for append the query results to an existing table?

CREATE OR REPLACE myTable  -- myTable will be replace every time...
SELECT
  id,
  parameter1,
  parameter2
FROM 
  third_party_managerd_table

Answer 1

Below is for BigQuery Standard SQL

#standardSQL
INSERT `project.dataset.yourtable` (id, parameter1, parameter2) 
SELECT
  id,
  parameter1,
  parameter2
FROM 
  `project.dataset.third_party_managerd_table`   

See more about BigQuery DML here - https://cloud.google.com/bigquery/docs/reference/standard-sql/dml-syntax

Answer 2

It can also be done by creating a new table with the new query and inserting it into "myTable"

CREATE OR REPLACE new_info
SELECT
  id,
  parameter1,
  parameter2
FROM 
  third_party_managerd_table;

INSERT INTO myTable
SELECT 
  n.*
FROM 
  new_info n;