Recently, I started exploring the Dash. For my analysis, I am fetching the data from databricks sql warehouse. The problem with that is it takes around 97 seconds to load the data to Dash.
The table which i am fetching has around 4,00,000 rows
Is there any other to achieve it in lesser runtime?
Welcome to the community!
If possible, could you run this task on a schedule and store the data in a paraquet file locally?
This would make it a lot easier to display in Dash.
You will find a lot of good information here: