Snowflake views

Snowflake views behave like most relational databases; they store a SELECT statement over physical objects as an object in a schema. Storing a SELECT statement as a shareable database object offers several advantages to users of the system:

• The SELECT statement does not need to be written from scratch each time it is required. This provides time savings and maintainability benefits through reusable modular code for data pipelines and analytics.
• Consistency in filters and business logic for everyone with access to the view.
• Views are separate database objects to the data sources they reference and can therefore have different permissions that do not expose all the underlying data.
• Can select data from multiple sources at once.
• Always shows the latest data from source tables without having to refresh it (as opposed to materializing the results as a physical table).
• Zero storage cost as data is not physically copied but read in real time when...