An analyst needs to create a view in Databricks SQL that aggregates sales data by region. Other analysts on the team should be able to query this view. Which SQL statement correctly creates a named, persistent view in Unity Catalog?

Question

Accepted Answer

B. CREATE VIEW main.analytics.sales_by_region AS SELECT region, SUM(amount) FROM sales GROUP BY region. To create a persistent view accessible to other analysts, it must be created with a fully qualified Unity Catalog name (catalog.schema.view_name) without the TEMP keyword. TEMP views are session-scoped and not visible to other sessions or users. `CREATE MATERIALIZED VIEW ... STORED AS PARQUET` is not valid syntax. `CREATE STREAM VIEW` is not a valid Databricks SQL statement.

An analyst needs to create a view in Databricks SQL that aggregates sales data by region. Other analysts on the team should be able to query this view. Which SQL statement correctly creates a named, persistent view in Unity Catalog?

Related Questions

Discussion