1M62u4V3

1/*
2  It would be really nice if Redshift prevented you
3  from creating invalid LBVs. Bound views are validated,
4  so I imagine it would be possible to validate LBVs too?
5  
6  View validation is common in other modern data warehouses which
7  implement their views as late-binding by default.
8*/
9
10
11create schema if not exists debug_lbvs;
12
13create table debug_lbvs.base_table as (
14
15	select 1 as id
16
17);
18
19/* This query succeeds */
20create view debug_lbvs.my_view as (
21
22	select notafield
23	from debug_lbvs.base_table
24
25) with no schema binding;
26
27/* This query fails */
28select * from debug_lbvs.my_view;