metabase查用户权限

1：查询每个用户所属用户组：

select a.email,b.name from metabase.core_user a
left join (select ma.user_id,group_concat(pg.name)  as name from permissions_group_membership ma
left join permissions_group pg on ma.group_id = pg.id
where pg.id<>1 group by 1) b on a.id=b.user_id
where a.is_active=1
order by 2;

2：查询报表查询记录：

select  b.email,a.error,date_add(started_at, interval 8 hour) as started_at,c.dataset_query,c.updated_at,c.name,round(running_time/1000,3) as running_time,result_rows,native,context,card_id,executor_id
from metabase.query_execution a
left join metabase.core_user b on a.executor_id=b.id
left join  metabase.report_card c on a.card_id=c.id
where a.started_at>'2020-01-11' and a.executor_id<>607 -- and a.error is not null
order by 3 desc;

3：查询