SnowConvert: Redshift Conditions
A BETWEEN condition tests expressions for inclusion in a range of values, using the keywords BETWEEN and AND.
SnowConvert: General Functional Differences
Views that select all columns from a single table without any filtering conditions (WHERE clause) are unnecessary in Snowflake and can negatively impact query performance.