Databricks · Databricks Data Analyst Associate
Tables, views, and streaming tables
Databricks Data Analyst Associate · Lesson 9 of 18 · 1:00:24
YouTube loads only after you press play. This chapter opens at its timestamp in the full course. Watch on YouTube ↗
In this lesson
Prepare for the Databricks Certified Data Analyst Associate exam. In this lesson: CREATE TABLE for managed and external tables, CREATE TABLE AS SELECT over read_files, CREATE OR REPLACE, standard and materialized views, refreshing them by hand, on a schedule, or when the sources change, and streaming tables for append-only data. Includes three original practice questions.
Preview the topics
- Partner bookings arrive as Parquet files in an external location. The analyst wants a managed table that holds these bookings, joined with the stores table to add each region, in a single SQL statement. Which statement fits?
- A materialized view feeds the workshop dashboard. It must catch up soon after its source tables change, and the analyst does not want a fixed timetable. Which clause fits?
- The workshop source table changes and deletes rows in place, all day long. The analyst wants a precomputed summary of it, brought up to date every hour. Which object fits?