tem_session

Column	Type
ur_ingest_session_id	TEXT
device_id	TEXT
session_name
ingest_started_at
ingest_finished_at
agent
version

SQL DDL

CREATE VIEW tem_session AS
SELECT
    ur_ingest_session_id,
    device_id,
    strftime('%m-%d-%Y %H:%M:%S', ingest_started_at) AS session_name,
    strftime('%m-%d-%Y %H:%M:%S', ingest_started_at) AS ingest_started_at,
    strftime('%m-%d-%Y %H:%M:%S', ingest_finished_at) AS ingest_finished_at,
    json_extract(session_agent, '$.agent') AS agent,
    json_extract(session_agent, '$.version') AS version
FROM ur_ingest_session
WHERE deleted_at IS NULL