acgz_processes

Select
(Select cube_id
    From (Select
                    value->>'cube_id' as cube_id
                From jsonb_array_elements(c.layer)) As v) As category_characteristics_v2
from charts c
-- inner join tables t on t.id like c.layers
Where c.id='5f7d3264-30d3-4463-af75-5270ab370281'


SELECT  c.layer->>'cube_id'
from charts c
-- inner join tables t on t.id like c.layers
where c.id='5f7d3264-30d3-4463-af75-5270ab370281';

Select
    f.*
    c.layer->'rows'->-1->'args'->-1->>'cube_id' AS layer
From charts c
Inner Join tables t on t.id =(c.layer->'rows'->-1->'args'->-1->>'cube_id')::int
Inner Join steps s on s.table_name=t.table_name
Inner Join flows f on s.flow_id=f.id
-- Inner Join dashboards d on d.
where c.id='9d4bc4b4-881b-4993-85b9-11b071a5ddc0'



select
    *
from dashboards c
where id='85a3c2eb-b617-4157-93f7-ae2c32a8218f'