Skip to content

Instantly share code, notes, and snippets.

@vithalsamp

vithalsamp/Redshift Create view.sql

Created February 26, 2018 06:32
Show Gist options
  • Save vithalsamp/65a4cf23e9f242c118ab6612685e7e44 to your computer and use it in GitHub Desktop.
Save vithalsamp/65a4cf23e9f242c118ab6612685e7e44 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Redshift Create view.sql
CREATE VIEW action_movies AS
SELECT *
FROM films
WHERE kind = 'Action';
training=# select * from action_movies;
code | title | kind | len
-------+------------+--------+----------
C_102 | Globe1 | Action | 01:40:00
C_101 | Globe | Action | 01:30:00
C_701 | Golden Eye | Action | 01:36:00
C_103 | Globe2 | Action | 01:30:00
C_104 | Globe3 | Action | 01:36:00
C_105 | Globe4 | Action | 01:37:00
(6 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment