SnowPro Advanced Data Scientist

By Snowflake · Question Mode

QuestionQ52

VerifiedPrepare data and use feature engineering in Snowflake

A Data Scientist must create a data set from columns across multiple tables and keep it automatically updated incrementally.

How can this be accomplished without writing an INSERT statement or checks for changes in the necessary tables?

Explanation

Dynamic tables materialize the result of a SELECT query, automatically track dependencies on the underlying tables, and refresh the result to meet a target lag. When incremental refresh is used, Snowflake computes only rows changed since the prior refresh, removing the need to write manual INSERT operations or source-table change-detection logic.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!