How-To Guides / Redshift How to create a view in Redshift database Syntax to create a view: create view viewname as (select statement ); Share this: Share on WhatsApp (Opens in new window) WhatsApp Share on Facebook (Opens in new window) Facebook Share on LinkedIn (Opens in new window) LinkedIn Share on Pinterest (Opens in new window) Pinterest Share on Reddit (Opens in new window) Reddit Related See also How to list all the databases in a Redshift cluster