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?
Cet exercice fait partie du cours
<cours>Intro to Snowflake for Devs, Data Scientists, Data Engineers</cours>Exercice interactif pratique
Transformez la théorie en action avec l’un de nos exercices interactifs
Commencer l’exercice