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:Click to share on WhatsApp (Opens in new window)Click to share on Facebook (Opens in new window)Click to share on LinkedIn (Opens in new window)Click to share on Pinterest (Opens in new window)Click to share on Reddit (Opens in new window) Related See also How to list Materialized views, enable auto refresh, check if stale in Redshift database