drewbanin

drewbanin

drewbanin

drewbanin

drewbanin

-- USAGE:

{{
    config(
        materialized='insert',
        dest_table='dbt_dbanin.table_to_insert_into',
        date_field="timestamp",
        start_date='2017-07-01'
   )
}}

drewbanin

create table public.test as (
  select 1 as id
);

create view public.test_view as (
  select * from public.test
);

drop table public.test;

drewbanin

create table public.test as (
  select 1 as id
);

-- NOTE: This is a late binding view. Note the
--       "WITH NO SCHEMA BINDING" clause at the
--       end of the `create view` statement.

create view public.test_view as (
  select * from public.test

drewbanin

select * from public.test_view;

ERROR:  relation "public.test" does not exist

drewbanin

create table public.test as (
    select 2 as id
);

select * from public.test_view;

--SELECT (it worked!)

drewbanin

/*
  This config will materialize this dbt model as a late-binding view.
  Note that dbt models are by-default materialized as views, so it's
  not always necessary to specify `materialized='view` here.
*/

{{ config(materialized='view', bind=False) }}

select * from public.test