Quick testing with values in Snowflake SQL using the VALUES function

,

Sometimes you just want to test something real quick in Snowflake and you need a table with some simple values.

The “VALUES” function can help. The SQL below speaks for itself.

SQL
SELECT
    ROW_NUMBER() OVER(ORDER BY 1) AS RANK,
    *
FROM (VALUES('Harry'),('David'),('Larry'),('Rambro'))
SQL