- kubectl exec into launcher
- log in to mysql
sql
SELECT *
FROM df_core.biz_chart
WHERE JSON_UNQUOTE(
JSON_EXTRACT(queries, '$[*].query.q')
) LIKE '%dcp-vehi%';sql
SELECT
t.dashboardUUID,
t.workspaceUUID,
t.name,
jt.q AS query_text
FROM df_core.biz_chart AS t
-- Shred each element of the topālevel array into its own row
JOIN JSON_TABLE(
t.queries,
'$[*]'
COLUMNS (
q TEXT PATH '$.query.q'
)
) AS jt
-- now filter each extracted query individually
ON jt.q LIKE '%dcp-vehi%';then let's take the dashboardID and then find out where does it belong to