Elsamadisi: Activity stream queries reuse consistent structures to bridge disparate systems
Ahmed Elsamadisi · How to Answer Data Questions Without Being Miserable // Ahmed Elsamadisi, Narrator (Data Driven NYC) · Nov 13, 2019 · at 9:58
Ahmed Elsamadisi, founder and CEO of Narrator.ai, presents the query efficiency benefits of using a single Activity Stream table instead of complex relational tables at Data Driven NYC.
0:00 / 0:14exact quote · 14.7s
▶ Watch the full episode on YouTube → 720p mp4 · rendered on demand · StarZero watermark
“The really fascinating thing here is that the query is so consistent. I can literally reuse the same query and combine layers of questions, all using the same structure, all being answered by the same table, bridging these systems invisibly.”
quote is from the automated transcript, cleaned for reading: filler sounds and stutters are removed, nothing is rephrased. names can be misheard (the analysis reads context, assessments check outside sources). how →
More from Ahmed Elsamadisi
Elsamadisi: Buying Looker requires hiring five to six BI engineers
“All it ends up doing is you end up having to hire a team of five or six BI engineers to write LookML and maintain these systems for you.”
Elsamadisi: Companies can replace hundreds of database tables with one time-series table
“So, instead of hundreds of fact and dimension tables, you can just have one time series table centered around a customer.”
Elsamadisi: Narrator reduced 40-hour Looker queries to just 10 minutes
“We've taken queries that were taking, like, literally 40 hours in Looker, and we've dropped them down to, like, 10 minutes. Queries that cross billions of rows end up happening in, like, seven to eight seconds on a warehouse.”
Elsamadisi: Redshift, Snowflake, and BigQuery perform identically on long tables
“The speed improvement on Redshift and versus Snowflake versus BigQuery becomes interchangeable. Because what they handle is for those edge cases, we have like a bunch of, like Snowflake is really good at a bunch of small tables everywhere trying to load a memo…”