Limit of table records or columns

Hi there,

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

Best,
Chris Schneider

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:

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

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

1 Like

That’s true, @dsun, good callout!

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.

@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