Limit of table records or columns

1

Hi there,

I’m wondering if there’s any limitation on the column count or entries in a table?

Best,
Chris Schneider

2

Hi @cschneider, welcome to the community!

The maximum columns available to any table are 200, including metadata fields (date_created, date_updated) and archived columns. You can toggle the visibility for these here:

Screen Shot 2023-02-03 at 8.46.05 AM
Screen Shot 2023-02-03 at 8.46.05 AM2512×606 63.3 KB

If you’re curious how many columns you’ve used, or how many you have available left in a given table, you can see this by mousing over the question mark next to the table name:

image

3

Also don’t forget archived columns right? They count towards your column count even though it’s “deleted”/archived.

1 Like
4

That’s true, @dsun, good callout!

5

To comment on your question regarding entries in a table (i.e. records), I wouldn’t worry about that one. From personal experience, a lot. :stuck_out_tongue:

That said, it’s important to note that analytics and queries can and will struggle or crash the more records you’re referring to. Not sure what that threshold is but it’s in the millions. Hope that helps.

6

@dsun and anyone else that runs into the 200 column limit because of archived fields-

Reach out to support@tulip.co and we can purge archived columns freeing up a little extra space.

Pete