Temporary or Staging table to avoid parallel execution on same set of tables for multiple charts

Question

Hi Team

Please advise whether we can create a temporary or staging table to avoid parallel execution on same set of tables for multiple charts.

Problem Statement:

In my dashboard i have 33 Charts/reports, most of them hit the same set of tables to retrieve data and it slows down the overall load time of the dashboard

Pease guide me on this

Thanks

Agaci Avinas · Answer

Hi @Ganesan Seethapathy ,

Thank you for reaching Atlassian Analytics support. I understand that your dashboard is slow due to the number of charts.

I would suggest you check our documentation on triaging performance issues here. Having said that, you can create custom tables in the data lake to handle parallel processing. You can find the steps to create custom tables on this page.

Feel free to reach us if you have any further questions.

Regards,

Agaci