The easy-to-use open source Business Intelligence and Embedded Analytics tool that lets everyone work with data :bar_chart:
TypeScript analyticsbibusiness-intelligencebusinessintelligenceclojuredashboarddatadata-analysisdata-visualizationdatabasemetabasemysqlpostgrespostgresqlreportingslacksql-editorvisualization
drop view if exists v_task_runs;
create or replace view v_task_runs as
select
id,
run_type,
entity_type,
entity_id,
case
when entity_type = 'database' then 'database_' || entity_id
when entity_type = 'card' then 'card_' || entity_id
when entity_type = 'dashboard' then 'dashboard_' || entity_id
else entity_type || '_' || entity_id
end as entity_qualified_id,
started_at,
ended_at,
case
when ended_at is not null then
cast(EXTRACT(EPOCH FROM (ended_at - started_at)) as double precision)
else null
end as duration_seconds,
status,
process_uuid,
updated_at
from task_run;