#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`