Commentary
- Wow! I like these videos. I learnt a lot too. It was passive knowledge true. But I came to know that these things are at least possible.
- Clickhouse as a database, the queries, we can use Material views which can be used as a CTE almost but on the fly, Endpoints to query them as a URL. WOW!
- The optimisation was based on the clickhouse features only, not sure if it would have been possible without it.