Mulai sekarangMulai gratis

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?

Latihan ini merupakan bagian dari kursus

Intro to Snowflake for Devs, Data Scientists, Data Engineers

Lihat Kursus

Latihan interaktif langsung

Ubah teori menjadi aksi dengan salah satu latihan interaktif kami

Mulai latihan