Hi Team, I have some large spreadsheets 100-125 columns that our client would like to display. However, I am hitting the maximum fields for a table at 50. Is there a way to work around this?

Hi Greg, you could try accessing the data via the API: https://www.gooddata.com/docs/cloud/api-and-sdk/api/access_raw_data_through_api/, although be aware that the general limits still apply, they can be found in the following page: https://support.gooddata.com/hc/en-us/articles/9703853324179-GoodData-Cloud-Limits. May I know why do you need accessing this number columns?

A client request for a lot of data columns. We are basically recreating a spreadsheet they have been doing by hand that tracks data over a years time. I can fit enough columns to show their dat through about 7 months but not through the rest of the year. They will not like the data being in two tables and requiring them to export both tables and manually join the tables together in 1 Excel spreadsheet. There is risk the manually doing this. Any reason the #columns in a tables can't be increased?

Hi Greg, I understand the frustration of needing to split into two tables and the concern about additional manual work. So I’d like to provide some details on why these limit exist. The limits, including the maximum number of cells, dimension size, and total query result size are in place to ensure the performance, stability, and reliability of the platform for all users. When a single query becomes too large (for example, by including a very high number of columns) this can cause performance degradation. Also network reliability, as large responses are more likely to fail due to timeouts or connectivity interruptions during download. Another factor is for consistency, as the platform is multi-tenant, so these limits help ensure one user’s heavy query cannot unintentionally impact others. Hope this helps help provide some clarity into why we have these limits in place.

Hi, I get it but that our clients are not so understanding. They want what they want. Please add this requested increase to the product backlog for consideration. My issue right now is for one client but I can see this will come up again. Thanks!

Hi Greg, thanks for getting back to me - I will go ahead and mark this as “product feedback” in this in case. Our team will then review this and consider this for future development