BaşlayınÜcretsiz başlayın

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.

Bu egzersiz, kursun bir parçasıdır

Introduction to Snowflake CoCo CLI

Kursa Göz Atın

Egzersiz talimatları

  • Start a CoCo session, press Ctrl+P to turn on plan mode, then ask for a table called SEGMENT_REVENUE with total revenue for each customer segment.
  • When the plan appears, press Tab, add "Also include the number of orders for each segment", and press Enter to approve it.
  • Once the table is created, close the session.

Uygulamalı etkileşimli egzersiz

Teoriyi etkileşime dönüştürün, interaktif egzersizlerimizden biriyle

Egzersize başla