Mark is joined by returning special guest Dan McClary to talk about data modeling and database design on distributed query engines such as Google BigQuery, the underlying Dremel technology and Capacitor storage format that enables this cloud distributed data warehouse-as-a-service platform to scale to petabyte-size tables spanning tens of thousands of servers, and techniques to optimize BigQuery table joins using nested fields, table partitioning and denormalization .

Drill to Detail Ep.31 'Dremel, Druid and Data Modeling on Google BigQuery' With Special Guest Dan McClary

Mark Rittman is joined each episode by a special guest from the world of business intelligence, analytics and big data.

Technology

Tech News

Podcasting

Gadgets

Software How-To

Business

Investing

Careers

Management & Marketing

Business News

Shopping

Marketing

Management

Mark Rittman is joined in this final episode of the current series of Drill to Detail by returning guest Jordan Tigani, Co-Founder & CEO at Motherduck to talk about the journey from big data to small data and bringing hybrid cloud execution to DuckDB.Big Data is DeadTeach Your Duckdb To FlyAnnouncing Motherduck: Hybrid Execution Scales Duckdb From Your Laptop Into The CloudDrill to Detail Ep.64 ‘Google BigQuery, BI Engine and the Future of Data Warehousing’ with Special Guest Jordan Tigani

Drill to Detail Ep.111 'Making Analytics Fun, Frictionless and Ducking Awesome' with Special Guest Jordan Tigani

Mark Rittman is joined in this special episode by previous Looker founder and inventor of the LookML language Lloyd Tabb together with Carlin Eng, Product Manager at Google Cloud to talk about Malloy, a new query language to replace SQL for analytics.Drill to Detail Ep.60 'A Deeper Look Into Looker' With Special Guest Lloyd TabbMalloy : An experimental language for dataA Sequel to SQL? An introduction to MalloyWhy SQL syntax sucks, and why it mattersComposing with QueriesDimensional Flexibility, one of the things that makes Malloy SpecialData is Rectangular and other Limiting MisconceptionsMalloy's Near Term Roadmap

Drill to Detail Ep.110 'Building a Sequel to SQL with Malloy' featuring Special Guests Lloyd Tabb and Carlin Eng

Mark Rittman is joined in this episode by returning guest and Elementl Founder Nick Shrock to talk about Dagster's role in the modern data stack ecosystem and software defined assets, a new, declarative approach to managing data and orchestrating its maintenance.Introducing Software-Defined AssetsRethinking Orchestration as Reconciliation: Software-Defined Assets in DagsterOptimizing Data Materialization Using Dagster’s PoliciesHow I use Dagster to orchestrate the production of social science data assets

Drill to Detail Ep.109 'Dagster, Orchestration and Software-Defined Assets' with Special Guest Nick Schrock

Mark Rittman is joined in this special episode of Drill to Detail by Benn Stancil, CTO and Founder at Mode to talk about their recent acquisition by ThoughtSpot, the economics of the modern data stack and how AI and LLMs could likely become our industry’s next discontinuity.We don’t need another SQL chatbotThe new philosophersThoughtSpot acquires Mode Analytics, a BI platform, for $200M in cash and stockChatGPT-Powered Data Analysis using Cube, Delphi and the Code Interpreter Plugin

Drill to Detail Ep.108 "Mode, ThoughtSpot and AI as the Next Discontinuity" with Special Guest Benn Stancil

Mark Rittman is joined in this episode by Artyom Keydunov, Founder at Cube to talk about embedded analytics and Cube's origin story, headless BI, query acceleration and how Cube and Delphi enable an AI-powered conversational interface for the semantic layer.Empower uniquely insightful AI & LLM data experiencesAI-powered conversational interface for the semantic layerDefine metrics upstream to align your teamHow Rittman Analytics Delivers the Semantic Layer Today with CubeRittman Analytics Cube Quickstart

Drill to Detail Ep.31 'Dremel, Druid and Data Modeling on Google BigQuery' With Special Guest Dan McClary

Download our free app to listen on your phone