Breaking News: Grepper is joining You.com. Read the official announcement!

big query add table rows to another table

FishBrawler answered on February 2, 2022 Popularity 1/10 Helpfulness 1/10

answer big query add table rows to another table

big query add table rows to another table

Comment

#standardSQL
INSERT INTO `project.dataset.copy_to_table` (id, parameter1, parameter2) 
SELECT
  id,
  parameter1,
  parameter2
FROM 
  `project.dataset.copy_from_table`
  
# For all columns
INSERT INTO `project.dataset.copy_to_table`
SELECT * FROM `project.dataset.copy_from_table`

Popularity 1/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: add rows sql

Link to this answer
Share Copy Link