Skip to content

Instantly share code, notes, and snippets.

@vogelsgesang

vogelsgesang/efficient_merge.sql Secret

Created December 1, 2021 17:44
Show Gist options
  • Save vogelsgesang/1e5b47e5c3c91f087eb6a8ad6cdc15b8 to your computer and use it in GitHub Desktop.
Save vogelsgesang/1e5b47e5c3c91f087eb6a8ad6cdc15b8 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
efficient_merge.sql
CREATE TABLE "output"."Extract"."Extract" AS
SELECT * FROM "input0"."Extract"."Extract" UNION ALL
SELECT * FROM "input1"."Extract"."Extract" UNION ALL
SELECT * FROM "input2"."Extract"."Extract" UNION ALL
SELECT * FROM "input3"."Extract"."Extract" UNION ALL
SELECT * FROM "input4"."Extract"."Extract" UNION ALL
SELECT * FROM "input5"."Extract"."Extract" UNION ALL
SELECT * FROM "input6"."Extract"."Extract" UNION ALL
SELECT * FROM "input7"."Extract"."Extract" UNION ALL
SELECT * FROM "input8"."Extract"."Extract" UNION ALL
SELECT * FROM "input9"."Extract"."Extract" UNION ALL
SELECT * FROM "input10"."Extract"."Extract" UNION ALL
SELECT * FROM "input11"."Extract"."Extract" UNION ALL
SELECT * FROM "input12"."Extract"."Extract"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment