Views — Question 2
Use the CREATE MATERIALIZED VIEW command to create a truck_franchise_materialized view, and base it on the same SQL query, reproduced here: SELECT t.*, f.first_name AS franchisee_first_name, f.last_name AS franchisee_last_name FROM tasty_bytes.raw_pos.truck t JOIN tasty_bytes.raw_pos.franchise f ON t.franchise_id = f.franchise_id; What description do you get in the result when you run the CREATE MATERIALIZED VIEW command?
Diese Übung ist Teil des Kurses
<Kurs>Intro to Snowflake for Devs, Data Scientists, Data Engineers</Kurs>Interaktive praktische Übung
Verwandle Theorie mit einer unserer interaktiven Übungen in die Praxis
Übung starten