https://docs.datastax.com/en/cql/dse-6.8/reference/cql-commands/create-materialized-view.html
CREATE MATERIALIZED VIEW | CQL for DataStax Hyper-Converged Database | DataStax Docs
Optimizes read requests and eliminates the need for multiple write requests by duplicating data from a base table.
create materialized viewhyper converged databasecqldatastaxdocs
https://docs.azure.cn/en-us/databricks/ldp/developer/ldp-sql-ref-create-materialized-view
CREATE MATERIALIZED VIEW (pipelines) - Azure Databricks | Azure Docs
Learn how to use the CREATE MATERIALIZED VIEW syntax in Databricks pipelines with Lakeflow Spark Declarative Pipelines SQL.
create materialized viewazure databrickspipelinesdocs