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.
Diese Übung ist Teil des Kurses
<Kurs>Introduction to Snowflake CoCo CLI</Kurs>Übungsanweisungen
- 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.
Interaktive praktische Übung
Verwandle Theorie mit einer unserer interaktiven Übungen in die Praxis
Übung starten