I want to insert the data in the Kibana Canvas table, but I do not work query.
How to get data using such a request?
SELECT * FROM A LEFT JOIN B ON A.key = B.key
SELECT a.id as idn, COUNT(*) as count, b.title as title
FROM "table_a" AS a
"table_b" AS b
GROUP BY idn
ORDER BY count DESC