Views — Question 3
Use the CREATE MATERIALIZED VIEW command to create a nissan view in the test_database database and the test_schema schema, based on this SQL query: SELECT t.* FROM tasty_bytes.raw_pos.truck t WHERE make = 'Nissan'; How many rows are in this nissan view?
This exercise is part of the course
Intro to Snowflake for Devs, Data Scientists, Data Engineers
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise