Skip to content
  1. kubectl exec into launcher
  2. 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