Skip to content

Instantly share code, notes, and snippets.

@drewbanin
Last active October 25, 2017 16:46
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save drewbanin/ed4d667cd1f8d4c145c43bc91d828226 to your computer and use it in GitHub Desktop.
Save drewbanin/ed4d667cd1f8d4c145c43bc91d828226 to your computer and use it in GitHub Desktop.
select
'analytics.uk_orders'::text as _dbt_source_table,
"id"::integer as "id",
"user_id"::character varying(255) as "user_id",
"price"::character varying(255) as "price",
"returned_at"::timestamp without time zone as "returned_at"
from analytics.uk_orders
union all
select
'analytics.us_orders'::text as _dbt_source_table,
"id"::integer as "id",
"user_id"::character varying(255) as "user_id",
"price"::character varying(255) as "price",
null::timestamp without time zone as "returned_at"
from analytics.us_orders
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment