A data analyst has created a dashboard using Databricks SQL. One of the queries inside it takes a long time to execute, causing the visualization on the dashboard to refresh slowly. What steps can the data analyst take to identify the root cause of this issue?