Question. Currently there is a 100k limitation on the gooddata UI for tables. Can i get around this by creating my own AG-grid like table in react and loop through the results by 100k

Hello Sebastiaan, I don't believe this will circumvent the table limitations, but you are welcome to give it a shot. You can, however, export raw data if needed: https://www.gooddata.com/docs/cloud/api-and-sdk/api/access_raw_data_through_api/

from your opinion, Is that the only thing that would allow us to use tables that have 100k+ rows?

You could try to build a custom visualization

Can i host these custom visualizations on goodata itself so i can use it within your platform or would i have to host it in my own platform

Hello @Sebastiaan abbink spaink, the limit is currently applied on the backend, not on the visualization (table) level. Building a custom visualization or dashboard plugin will not help to display more results at once unless you feed it with raw export as @Joseph Heun recommended. GoodData is however currently investigating to relax these limits and to display partial results if needed, so there wouldn’t be a need for custom development. Would you be willing to share your workflow with these 100k+ results? You already mentioned that this amount of results should be visible after applying all the important filters. What will your users do when seeing a table with such an amount of results?