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.
Deze oefening maakt deel uit van de cursus
Introduction to Snowflake CoCo CLI
Oefeninstructies
- 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.
Interactieve oefening met praktijkervaring
Zet theorie om in actie met een van onze interactieve oefeningen
Begin oefening