Skip to content
Table SQL Pack - User Guide
Get starts with the Table SQL Pack for Coda
More
Share
Explore
Get starts with the Table SQL Pack for Coda

icon picker
More information

Row limit

A Coda Pack execution is limited to one minute, which isn’t a lot of time if you are working with a large amount of data. To ensure that the Pack can execute successfully it will throw an error if you try to load more than 10,000 rows.

Update delay

This Pack uses the Coda API to fetch the table information, and changes to your doc may sometimes take a minute or more to be reflected in the API. When adding new columns or rows, wait a minute writing a query against them.

Caching

In order to help improve performance, especially when writing formulas, the Pack will cache your table data for a short period of time (currently one minute).

Avoid SELECT *

You should avoid using SELECT * in your queries because:
It will return internal columns meant to help with
Joining tables
⁠
(_display and _id ).
When joining multiple tables, columns with the same name will overwrite each other.

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.