talk-data.com talk-data.com

N

Speaker

Niall Woodward

3

talks

Co-founder SELECT

Frequent Collaborators

Filter by Event / Source

Talks & appearances

3 activities · Newest first

Search activities →
From slow to swift: Proven methods for optimizing your dbt project - Coalesce 2023

With increased adoption of dbt and ever growing data volumes, data teams are increasingly looking to make their dbt deployments more efficient. The problem? Practitioners aren’t equipped with the tools and strategies to do this well. In this talk, Ian Whitestone and Niall Woodward of SELECT share a variety of dbt cost and performance optimization best practices, diving into the actual strategies they’ve deployed with numerous companies to give practitioners immediately actionable techniques they can apply to their own projects.

Speakers: Ian Whitestone, Co-founder, SELECT; Niall Woodward, Co-Founder, SELECT

Register for Coalesce at https://coalesce.getdbt.com

The Missing Manual: Everything You Need to Know about Snowflake Optimization | SELECT

ABOUT THE TALK Learn all about cost and performance optimization in Snowflake. This talk deep dive's into Snowflake’s architecture & billing model, covering key concepts like virtual warehouses, micro-partitioning, the lifecycle of a query and Snowflake’s two-tiered cache. It then goes in depth on the most important optimization strategies, like virtual warehouse configuration, table clustering and query writing best practices. Throughout the talk, code snippets and other resources are shared to help you get the most out of Snowflake.

ABOUT THE SPEAKERS Niall Woodward and Ian Whitestone are the co-founders at SELECT, a tool to help Snowflake users optimize their Snowflake cost & performance.

Niall Woodward has been well known in the data community for creating and contributing to open source packages.

Ian Whitestone previously led data teams at Shopify and Capital One. At Shopify, Ian spearheaded the efforts to reduce their data warehouse spend by over 50%.

ABOUT DATA COUNCIL: Data Council (https://www.datacouncil.ai/) is a community and conference series that provides data professionals with the learning and networking opportunities they need to grow their careers.

Make sure to subscribe to our channel for the most up-to-date talks from technical professionals on data related topics including data infrastructure, data engineering, ML systems, analytics and AI from top startups and tech companies.

FOLLOW DATA COUNCIL: Twitter: https://twitter.com/DataCouncilAI LinkedIn: https://www.linkedin.com/company/datacouncil-ai

Brad Culberson is a Principal Architect in the Field CTO's office at Snowflake. Niall Woodward is a co-founder of SELECT, a startup providing optimization and spend management software for Snowflake customers. In this conversation with Tristan and Julia, Brad and Niall discuss all things cost optimization: cloud vs on-prem, measuring ROI, and tactical ways to get more out of your budget. For full show notes and to read 6+ years of back issues of the podcast's companion newsletter, head to https://roundup.getdbt.com.  The Analytics Engineering Podcast is sponsored by dbt Labs.