Plan before you build
Finance is setting next year's budget by customer segment and wants revenue for Consumer, Business, and Education customers saved in a SEGMENT_REVENUE table. It joins three tables, so have CoCo plan the work first and review the plan before anything runs.
Cet exercice fait partie du cours
<cours>Introduction to Snowflake CoCo CLI</cours>Instructions de l’exercice
- Start a CoCo session, press
Ctrl+Pto turn on plan mode, then ask for a table calledSEGMENT_REVENUEwith total revenue for each customer segment. - When the plan appears, press
Tab, add "Also include the number of orders for each segment", and pressEnterto approve it. - Once the table is created, close the session.
Exercice interactif pratique
Transformez la théorie en action avec l’un de nos exercices interactifs
Commencer l’exercice