Skip to content

Instantly share code, notes, and snippets.

@jeffschulthies

jeffschulthies/gist:7134a714dd19f6118daa5d97c5e70c6b

Last active August 30, 2016 19:50
Show Gist options
  • Save jeffschulthies/7134a714dd19f6118daa5d97c5e70c6b to your computer and use it in GitHub Desktop.
Save jeffschulthies/7134a714dd19f6118daa5d97c5e70c6b to your computer and use it in GitHub Desktop.
Download ZIP
Demo DWH
Raw
gistfile1.sql
CREATE TEMPORARY TABLE "EBSM5VR0B" AS (
SELECT "t0"."ProductID" "productid"
FROM
"public"."products" "t0"
) WITH DATA;
SELECT
"t0"."productid" "productid",
"t1"."productid" "inventory_db__mysql_1_productid"
FROM
"EBSM5VR0B" "t0"
FULL JOIN "@[Inventory DB (MySQL)1]" "t1" ON (("t1"."productid" = "t0"."productid"))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment