Table SQL Pack - User Guide

Get starts with the Table SQL Pack for Coda

Explore

Get starts with the Table SQL Pack for Coda

Learn how to query your Coda tables using SQL.

Coda come with a ton of useful table features baked in, like lookups, formulas, filters, and more. But sometimes there’s nothing like good ‘ol fashioned SQL when you want to do some particularly complex queries.

Enter the Table SQL Pack!

⁠

This link can't be embedded.⁠

⁠

Demo

If you’ve got a table of data in your doc...

Employees

Employees

Last Name

First Name

Title

Hire Date

Country

Davolio

Nancy

Sales Representative

5/1/1992

USA

Fuller

Andrew

Vice President Sales

8/14/1992

USA

Leverling

Janet

Sales Representative

4/1/1992

USA

Peacock

Margaret

Sales Representative

5/3/1993

USA

Buchanan

Steven

Sales Manager

10/17/1993

Suyama

Michael

Sales Representative

10/17/1993

King

Robert

Sales Representative

1/2/1994

Callahan

Laura

Inside Sales Coordinator

3/5/1994

USA

Dodsworth

Anne

Sales Representative

11/15/1994

There are no rows in this table

⁠

You can use this Pack to query it with SQL syntax...

Queries

Queries

Description

Query

Result

Count of employees

SELECT COUNT(*) FROM Employees;

[9]

Employees that start with “M”

SELECT `First Name`, Title

FROM Employees

WHERE `First Name` LIKE 'M%';

[MargaretSales Representative][MichaelSales Representative]

Year of most recent hire, by country

SELECT

Country,

MAX(strftime('%Y',`Hire Date`)) AS Year

FROM Employees

WHERE Title = 'Sales Representative'

GROUP BY Country;

[UK1994][USA1993]

Numbers of employees broken down by country and title

SELECT

Country,

Title,

COUNT(*) as NumEmployees

FROM Employees

GROUP BY Country, Title;

[UKSales Manager1][UKSales Representative3][USAInside Sales Coordinator1][USASales Representative3][USAVice President Sales1]

There are no rows in this table

⁠

Try it out!

Add your own queries to the table above to see the Pack in action.

Get started

First, install the Pack:

Install

⁠

Then read through the guide to learn how to use it in your doc.

Name

Description

⁠

Building blocks⁠

An overview of the different building blocks included in the Pack (all of the different ways to run queries).

⁠

Loading Tables⁠

How to specify which tables to load when performing a query.

⁠

Query language⁠

Some information about the flavor of SQL you can use.

⁠

Joining tables⁠

Tips and tricks for joining tables together.

⁠

More information⁠

Additional information about the Pack.

There are no rows in this table

⁠

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.