Get startedGet started for free

Meet CoCo

1. Meet CoCo

Hi, I'm James, a Senior Developer Advocate at Snowflake. Welcome to the course, where you'll learn to put CoCo to work from your terminal.

2. What CoCo is

CoCo is Snowflake's AI coding agent, built for data teams. You describe a task in plain language, and CoCo writes the SQL or Python it needs and runs it.

3. Built for your data

Plenty of AI tools write code. What makes CoCo different is that it's connected to your Snowflake account, so it knows your tables, your permissions, and how your data fits together.

4. Built for your data

It also reads the files in the folder you start it from, so it can see the SQL and scripts you already have.

5. What teams build

Data teams use CoCo across their day-to-day work. They build pipelines, write analyses, train models, and stand up apps on top of their data.

6. Ask for the outcome

Whatever the task, one habit is worth forming early. Describe the outcome you want, not the steps to get there.

7. Ask for the outcome

Rather than walking CoCo through a select, a group by, and a sort, ask which product your customers rate worst. Working out how is CoCo's job.

8. You're in the loop

You're in the loop throughout. Before CoCo edits a file or runs something that changes your data, it asks, and you approve or decline.

9. You're in the loop

There are also different modes for how much it can do without asking, so you decide how closely to supervise it.

10. Where CoCo runs

CoCo isn't one app. It runs in four places, sharing the same agent underneath.

11. Where CoCo runs

Desktop is a native app on your Mac or Windows machine, with your local files in reach.

12. Where CoCo runs

The CLI lives in your terminal.

13. Where CoCo runs

In Snowsight, CoCo sits inside Snowflake Workspaces and Notebooks.

14. Where CoCo runs

And Extensions plug it into VS Code and dozens of other editors.

15. Where CoCo runs

We'll spend this course in the CLI.

16. Why the terminal

So why work in the terminal? There are three good reasons. A terminal command can be scripted, so anything you do by hand can later run on a schedule with nobody watching.

17. Why the terminal

It also works directly on your project, editing files in place rather than in a browser tab.

18. Why the terminal

And plenty of technical people simply prefer it, spending their whole day in a terminal and wanting their AI assistant in the same place.

19. Starting a session

Starting CoCo is one word. Type cortex in your terminal and the session opens, already signed in to Snowflake and ready for your first question.

20. The command menu

Most of the time you just describe what you need in your own words. But a handful of commands control the session itself, and they're worth knowing. Type a forward slash and CoCo lists them all, searchable, so you never have to remember one.

21. Check your session

The one command worth running first is status. It shows which model you're on, how much CoCo is allowed to do without asking, and whether your Snowflake connections are live. If something isn't working, that's where you look.

22. Choosing a model

CoCo can run on a range of models, and the model command opens a picker to switch between them. In the exercises we'll stay on Auto, which balances quality against cost, so it's a sensible default to leave alone.

23. Leaving CoCo

When you're finished, the quit command closes the session and drops you back to your terminal prompt, where you started. CoCo keeps a record of the conversation, so you can pick a session back up later by its id.

24. Let's practice!

You've met CoCo and the commands that get you around it. Now let's put it to work.

Create Your Free Account

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.