Snowflake ProTalk
mastering dynamic tables and reference passing

Unleash the power of Dynamic Tables in Snowflake and revolutionize your data processing approach. Dynamic Tables are not just a feature; they're a game-changer. They allow you to define the end state of your data transformations, eliminating the need for complex streams, tasks, and exhaustive orchestration. 

Imagine a world where you no longer have to manage intricate data pipelines. Instead, you define what you want your data to look like, and Snowflake takes care of the rest. Dynamic Tables materialize the results of your queries and keep them updated automatically, freeing you from the burden of manual updates. This streamlined approach not only simplifies your data engineering process but also reduces the risk of errors and increases overall efficiency. 

Incorporating Dynamic Tables enables your organization to focus more on deriving insights from data and less on managing data pipelines, representing a smarter, more efficient way of handling data engineering.  With Dynamic Tables, you're not just working on your data; you're letting your data work for you. 

Embrace the future of data engineering with Dynamic Tables in Snowflake.

Key Learning Points:

  • Deep-dive into the concept of Dynamic Tables in Snowflake, the cornerstone of declarative data transformation pipelines.
  • Understand how Dynamic Tables redefine data engineering by encapsulating the end state of transformations.
  • Learn the intricacies of materializing query results using Dynamic Tables and ensuring their automatic updates.
  • Discover the optimal use cases for Dynamic Tables and the art of chaining together pipelines of Dynamic Tables for efficient data management.
  • Get an introduction to the power of Stored Procedures in Snowflake, with a spotlight on the ability to pass references.
  • Gain a basic understanding of creating and using references to tables, views, or functions, enabling Stored Procedures to perform SQL actions on these objects.
Sasha Lionheart Snowflake Circle


Tech lead and manager on Snowflake's Dynamic Tables team. Prior to Snowflake, he spent over a decade immersed in a range of infrastructure projects, spanning storage, networking, and compute, before zeroing in on data analytics.

Rich BW


As Enterprise Data Solutions Architect at INTRICITY, Rich has deployed Snowflake in several dozen Fortune 500 accounts and designs and delivers orchestration, modeling, security and strategy to enable elastic cloud data warehousing.

Jonas BW


Jonas is a forward-thinking data architect with 15 years of experience. He specializes in Looker, Snowflake, NoSQL, Python, and AWS, and is passionate about driving future state architectures. 

Jared BW


Jared acts as our Vice President of Emerging Technologies and is the host of our Snowflake ProTalk webinar series. Listed as one of the “Top Marketing Operations Leaders You Should Know” and is the author and creator of our INTRICITY101 video series.

Register Here

appears invalid. We can send you a quick validation email to confirm it's yours