How many columns can I create in a single Data Store table, and can the limit be raised?
Catalyst CloudScale Data Store allows up to 100 columns in each table by default. Catalyst support can raise this for a table on request, case by case and up to a maximum. When a table reaches its limit, creating a column fails with an API limit error, which can mention the table limit even though the column limit was reached.
-
Check whether the table needs that many columns. Repeating groups of fields often work better as a child table linked by a Foreign Key column.
-
To ask for more, contact Catalyst support with your project, the Table ID of each table, how many columns you need and what the table is for.
-
A raise applies to the tables you name. Ask again for tables you create later.
-
When Support confirms the raise, refresh the console and add the columns.
Note: Text, Var Char and Encrypted Text columns also have a combined limit per table, which a raise of the total column limit doesn’t change.
Refer to the Columns help page for more information.
Updated
Yes
No
Send your feedback to us
Ask AI about this answer