Look without touching
You're preparing for a quarterly review and want to explore the customer data with no risk of changing it, so you start CoCo read-only. Then your manager asks you to save the five biggest spenders as a TOP_CUSTOMERS table. See how read-only handles that request, then lift the restriction and save the table.
यह अभ्यास पाठ्यक्रम का हिस्सा है
Introduction to Snowflake CoCo CLI
अभ्यास निर्देश
- Start CoCo with
cortex --sql-read-only, ask it to save the five customers with the highest total spend as a table calledTOP_CUSTOMERS, and approve the statement. - Once Snowflake refuses it, type
/guardrailsand remove the current restriction. - Ask CoCo to save the table again, and approve it.
- Close the session.
इंटरैक्टिव व्यावहारिक अभ्यास
हमारे इंटरैक्टिव अभ्यासों में से किसी एक के साथ सिद्धांत को व्यवहार में बदलें
अभ्यास शुरू करें