How to create a view in Redshift database

Syntax to create a view:

create view viewname as
(select statement      
);                     
See also  How to list Materialized views, enable auto refresh, check if stale in Redshift database