Skip to content

Instantly share code, notes, and snippets.

@Wittline

Wittline/insert_to_fact.sql

Created June 1, 2022 19:45
Show Gist options
  • Save Wittline/fcbc8773f4f92d5dc282f3428fcc1422 to your computer and use it in GitHub Desktop.
Save Wittline/fcbc8773f4f92d5dc282f3428fcc1422 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
insert_to_fact.sql
insert into {project}.{dataset}.{tablefinal}
(id, category, lastdate)
select id, category, lastdate
from {project}.{dataset}.{table1}
union all
select id, category, lastdate
from {project}.{dataset}.{table2}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment