Apache Cassandra - Tutorial 13 - CQL - Materialized Views

We will continue our tutorial on using Cassandra Query Language on an Apache Cassandra database by looking at the concept of Materialized Views.

Materialized views help us overcome some of the data access problems faced in Cassandra where often multiple different versions of a table must exist each with at different partition key. By using materialized views Cassandra can abstract some of this away from the developer as it maintains the additional tables created during the materialized view process.

[golfclash]

Does materialised view copy original table and consumes the disk/memory space or does it only create view with pointers to data without consuming disk space?

[nikola]

How would you approach solving problem on sorting? Like, for example, you can sort on all columns?

[n.s.karthik]

is there any advantage for materialized views over secondary indexes?

[edsonr.]

Thanks for the video! It was very helpful 😄

[mritunjay]

Can you provide us with the python driver connection to datastax astra database?