Hi Team how i can see the sql query behind the widget from the liveboard page not from Analyze tab

The

/debug

URL trick works from the Analytical Designer (Analyze tab), not directly from a dashboard/liveboard page. However, you can get there easily without leaving the dashboard context: Use "Explore from here" on the dashboard widget: 1. On the dashboard, find the widget you want to inspect. 2. Click the widget's options menu and select "Explore from here" (or a similar option like "Open in Analyze"). This opens the visualization in the Analytical Designer. 3. Once in Analytical Designer, the URL will end with

/edit

. Replace

/edit

with

/debug

in the browser address bar and press Enter. 4. This will silently download a ZIP file (usually named

explainAfm.zip

) to your browser's Downloads folder — no new tab will open. 5. Inside the ZIP, look for the file

report.json.qt.opt.sql

— this contains the actual SQL query sent to your database. [Debug URL method] If

/debug

doesn't download anything: • Check your Downloads folder first — the file downloads silently. • If it still fails (e.g., for large/complex models), try appending a parameter instead:

.../debug?explainType=SQL

[Large model workaround] There is no way to get the SQL directly from the dashboard/liveboard page itself — going through Analytical Designer (via "Explore from here") is the supported path. 👍 0 button 👎 0 button ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups. 👀 Our Support team monitors all messages and will jump in if needed.

Hi Raghav, I can confirm that the debug file functionality works only in Analytical designer.