Drill to Detail Ep.64 ‘Google BigQuery, BI Engine and the Future of Data Warehousing’ with Special Guest Jordan Tigani

Mark Rittman is joined in this episode by Jordan Tigani, Director of Product Management at Google for Google BigQuery, to talk about the history of BigQuery and its technology origins in Dremel; how BigQuery has evolved since its original release to handle a wide range of data warehouse workloads; and new features announced for BigQuery at Google Next’19 including BI Engine, Storage API, Connected Sheets and a range of new data connectors from Supermetrics and Fivetran.

• Modern Data Warehousing with BigQuery (Cloud Next '19)

• Modern data warehousing with BigQuery: a Q&A with Engineering Director Jordan Tigani

• Introduction to BigQuery BI Engine

• BigQuery Storage API Overview

• Supermetrics and Fivetran BigQuery connectors

• Drill to Detail Ep.2. 'Future of SQL on Hadoop', With Special Guest Dan McClary

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

Drill to Detail Ep.64 'BigQuery, BI Engine and the Future of Data Warehousing’ with Jordan Tigani

Mark Rittman

Download

Drill to Detail Ep.50 'Agile BI, Karl Marx and Our Man from Moscow' With Special Guests Stewart Bryson and Alex Gorbachev

Mark Rittman is joined in this 50th Episode Special by our original guest on the first episode of Drill to Detail, Stewart Bryson, to talk about developing agile BI applications using FiveTran, SnowflakeDB and Looker and his recent work developing a BI solution for Google Play Marketing using Google Data Studio and Google Cloud Platform. We're also joined later in the show by Alex Gorbachev from Pythian, our mystery guest who Stewart then interviews flawlessly armed only with a set of questions given to him as the guest was unveiled ... though be sure to listen past the final closing music for the bonus out-takes.

• #115 Google Play Marketing with Dom Elliott and Stewart Bryson
• The Next-Generation Jump Program
• The Data Sharehouse is Here
• From Data Warehouse to Data Sharehouse
• Alex Gorbachev profile on Pythian.com

Drill to Detail Ep.50 'Agile BI & Our Man from Moscow' With Stewart Bryson & Alex Gorbachev

Mark Rittman

Download

Drill to Detail Ep.49 'Trifacta, Google Cloud Dataprep and Data Wranging for Data Engineers' With Special Guest Will Davis

Mark Rittman is joined by Will Davis from Trifacta to talk about the public beta of Google Cloud Dataprep, Trifacta's data wrangling platform and topics including metadata management, data quality and data management for big data and cloud data sources.

• Google Cloud Dataprep on Google Cloud Platform
• "Google Cloud Dataprep: Spreadsheet-Style Data Wrangling Powered by Google Cloud Dataflow"
• "A New Cloud-Based Data Prep Solution from Google & Trifacta"
• Trifacta website
• "A Breakthrough Approach to Exploring and Preparing Data"
• Trifacta platform architecture
• "Garbage In, Garbage Out: Why Data Quality Matters"
• "How to Put an Effective Metadata Strategy in Place"

Drill to Detail Ep.49 'Trifacta, Google Dataprep and Data Wranging' With Special Guest Will Davis

Mark Rittman

Download

Drill to Detail Ep.41 'Developing with Google BigQuery and Google Cloud Platform' With Special Guest Felipe Hoffa

Mark is joined in this episode by Google Cloud Platform Developer Advocate Felipe Hoffa, talking about getting started as a developer using Google BigQuery along with Google Cloud Dataflow, Google Cloud Dataprep and Google Cloud Platform's machine learning APIs.

• Reddit BigQuery Forum
• Felipe Hoffa on Stack Overflow
• Felipe Hoffa on Medium
• Google Cloud Dataprep
• "How to aggregate data for BigQuery using Apache Airflow"
• Google Cloud Platform Github Repo

Drill to Detail Ep.41 'Developing with BigQuery and Google Cloud' With Special Guest Felipe Hoffa

Mark Rittman

Download

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

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 columnar 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.

• Dremel: Interactive Analysis of Web-Scale Datasets
• BigQuery under the hood
• Inside Capacitor, BigQuery’s next-generation columnar storage format
• Drill To Detail Ep.2. 'Future Of SQL On Hadoop', With Special Guest Dan McClary
• Google BigQuery, Large Table Joins and How Nested, Repeated Values and the Capacitor Storage Format (and Looker) Saves the Day

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

Mark Rittman

Download

Drill to Detail Ep.16 'Qubit, Visitor Cloud & Google BigQuery' With Special Guest Alex Olivier

Mark Rittman is joined by Alex Olivier from Qubit to talk about their platform journey from on-premise Hadoop to petabytes of data running in Google Cloud Platform, using Google Cloud Dataflow (aka Apache Beam), Google PubSub and Google BigQuery along with machine learning and analytics to deliver personalisation at-scale for digital retailers around the world.

• Qubit Visitor Cloud and Qubit's Infrastructure
• "A new age of Machine Learning is here" - Qubit Blog
• How Qubit's Data Supply Chain Shows the Power of HBASE
• Big Data Analytics at Google Scale
• BigQuery for Data Warehouse Practitioners
• Alex Olivier on Qubit's Infrastructure at Google NEXT London 2016

Drill to Detail Ep.16 'Qubit, Visitor Cloud & Google BigQuery' With Special Guest Alex Olivier

Mark Rittman

Download