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.
Questo esercizio fa parte del corso
Introduction to Snowflake CoCo CLI
Istruzioni dell'esercizio
- 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.
esercizio interattivo pratico
Trasforma la teoria in pratica con uno dei nostri esercizi interattivi
Inizia esercizio