Keep review topics up to date
Earlier in this chapter, you saved LOW_RATING_REASONS for the product team. That table only holds the reviews that existed when you saved it, and new ones arrive every day. This time, the team wants a table of review topics that stays up to date on its own. We've created a PIPELINE schema for you to build it in.
This exercise is part of the course
Introduction to Snowflake CoCo CLI
Exercise instructions
- Start a CoCo session and paste this prompt:
Create a dynamic table PIPELINE.REVIEW_TOPICS that labels each review in SHOP.REVIEWS with one topic: quality, delivery, price, support, or other. It should stay up to date within a minute of a new review. - Before you approve, check that the
Execute SQLbox shows a dynamic table, a one-minute target lag, an AI function, andSHOP.REVIEWSas the source. - After a minute or two, ask CoCo to check the history of
REVIEW_TOPICSand see whether it has refreshed since. - Close the session.
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise