Hey all,
Question about insights, we used to be able to replace /edit with /debug to download a payload containing the query and other various metadata about an insight. Did that go away?
Steve Fox
11/12/2024, 10:47 PM
I really hope this didn't go away as it was our only way of diagnosing what the actual query was against our physical data model.
Steve Fox
11/12/2024, 10:49 PM
ok, looks like it still works, phew. Not sure what was going on but i saved the insight as new then tried again.
i
Ivana Gasparekova
11/12/2024, 10:56 PM
Hey Steve,
Yes, I can confirm the endpoint is still alive. Not quite sure why it didn't work as expected during your initial attempt.
Please let me know if the issue reappears and/or affects any other insight.
BTW, I believe that you might find AFM explain resource useful as well.
🙏 1
s
Steve Fox
11/13/2024, 2:30 AM
hmm, interesting, meaning through the api we can explore and find the actual sql query.
Steve Fox
11/13/2024, 2:31 AM
Often times, I find that the best way to diagnose an issue is through creating the exact analytical object through cloning to then get the query behind the scenes. So its the combination of unique attributes or filters that are needed to expose any data issues.
Either way this is very useful. Thank you