Hi team, I need support regarding the need for a performance boost on our dashboards/visualizations. We connected a new SnowFlake data source with millions of items. The queries we make on Snowflake are super fast, but the GoodData dashboards/visualizations take minutes to load the data. We think there might be an issue with GD handling large data sources, or there's something we don't know to boost the dashboards' performance. Could you please suggest how we can improve the performance of processing a large data source? Thanks in advance!

Hi Emir, May I know what number of columns per table are we roughly talking about here please? Note that there are also some platform limits in play which you should consider: https://support.gooddata.com/hc/en-us/articles/9703853324179-GoodData-Cloud-Limits Does the analytics usually time out for you or is it only slow but loads the data eventually? There is a way how to actually check the SQL generated on our end which querries your data source. Once you create a vizualisation, navigate to it via the Analytical Designer and change /edit to /debug in the browser URL. This will download a debug file containing the SQL which you can compare with the performance of queries triggered directly above your data source. Let us know about the result.

Hi Julius, thanks for the response!! The visualization I'm doing the performance tests on is a table that has 19 metric columns and 3 attribute columns, with 1 attribute and 2 metric filters. I checked the SQL generated and ran it on Snowflake directly and it took too long to process there too... (+30 mins, for reference) What would your suggestion be in this case? Are there any solutions without making changes on the number of columns in the visualization? The visualization's performance is good for other clients that have smaller data, so we wouldn't like to change the visualization itself if possible.. I can share the generated SQL with you if it's useful

Hi Emir, I would definitely suggest you to study the below documentation about possible improvement of a database performance: https://www.gooddata.com/docs/cloud/connect-data/performance/

Hi Julius, thanks for the suggestion, we'll review and apply the ones we can. I'll update here with the results!