#JOIN2019: The Effect of Relational Algebra on Looker's Query Engine

November 22, 2019
#JOIN2019 Session No. 12: "Smarter Together: Bringing Relational Algebra, Powered by Apache Calcite, into Looker's Query Engine" What if Looker saw the queries you just executed and could predict your next query? Could it make those queries faster, by smarter caching, or aggregate navigation? Could it read your past SQL queries and help you write your LookML model? Those are some of the reasons to add relational algebra into Looker’s query engine, and why Looker hired Julian Hyde, author of #ApacheCalcite, to lead the effort. In this session about the internals of Looker’s query engine, Julian Hyde describes how the engine works, how Looker queries are described in Calcite’s relational algebra, and some features that it makes possible.
Previous Video
#JOIN2019: Getting Started with Programmatic LookML Generation
#JOIN2019: Getting Started with Programmatic LookML Generation

#JOIN2019 Session No. 15: "Flexible Schemas, I'm Gonna Automate You" The flexibility of LookML in data mo...

Next Video
#JOIN2019: Demographic & Behavioral Lead Scoring Strategy
#JOIN2019: Demographic & Behavioral Lead Scoring Strategy

#JOIN2019 Session No. 31: "Canvas Solutions: Evolving Lead Scoring Strategy" Lead scoring can change how ...