Skip to content

The easy-to-use open source Business Intelligence and Embedded Analytics tool that lets everyone work with data :bar_chart:

292 B
Raw Blame
drop view if exists v_tasks;

create or replace view v_tasks as
select
    id,
    task,
    status,
    concat('database_', db_id) as database_qualified_id,
    started_at,
    ended_at,
    cast(duration as double) / 1000 as duration_seconds,
    task_details as details
from task_history;