Next Webinar →Build a self-serve agent, live | 20 MAY

5. SQL cells: Getting Started in Count

Explore SQL cells in Count: Name, code, and query results in individual cells. Reference and build upon other cells for dynamic data exploration.

1:12.033299999999997

Transcript

Let's look at what is in a SQL cell. Well, it has a title. I'm going to give it a better name. It has some SQL code, and it has the results of this query. Unlike other tools where we might build up our SQL code in one place, KIND allows us to explore our data in a sequence of individual cells. And all of our cells can use the results of any other cell. So let's see what that looks like. I'm going to hover over my selected SQL cell to add a new cell. There are various types, but I'm going to stick with SQL. Here you can see the start of some suggested SQL and it's referencing accounts. And this is what I called my SQL cell originally, and that's why it's important to name yourselves well as this is what we use to reference other cells. So I'm going to go ahead and add some more SQL here. So here we can see the results. We can see that this is a subset of the cell that I've pre read because I have included, filter on it. Let's