Running a full-fledged analytical database inside the client opens up new ways of executing your query; you can run parts of your query locally and part remotely. Once you can split the query plan into two pieces, the same mechanism works with N stages, which can be in series or a tree. This talk discusses the hybrid execution system based on DuckDB built at MotherDuck, but also discusses some further query topologies that are enabled by this pattern.
Speaker: Jordan Tigani, Co-Founder & Chief Duck-Herder, MotherDuck
Register for Coalesce at https://coalesce.getdbt.com