5min chapter

Explicit Measures Podcast cover image

78: Talking About Incremental Refresh

Explicit Measures Podcast

CHAPTER

What Is Incremental Refresh?

Incremental refresh is a feature that allows us to speed up our refresh of certain tables within ore ourmodel. It takes a really long time to load all of that data that you want to pull into the model. So incremental refresh allows us to segment out by certain time ranges, and these are called partitions a the fact table. And it also creates less of an impact on your source systems because you're not extracting all the data all the time. That's huge when you start getting into many models and larger models, for capacity, on any of your premium stuffs.

00:00

Get the Snipd
podcast app

Unlock the knowledge in podcasts with the podcast player of the future.
App store bannerPlay store banner

AI-powered
podcast player

Listen to all your favourite podcasts with AI-powered features

Discover
highlights

Listen to the best highlights from the podcasts you love and dive into the full episode

Save any
moment

Hear something you like? Tap your headphones to save it with AI-generated key takeaways

Share
& Export

Send highlights to Twitter, WhatsApp or export them to Notion, Readwise & more

AI-powered
podcast player

Listen to all your favourite podcasts with AI-powered features

Discover
highlights

Listen to the best highlights from the podcasts you love and dive into the full episode