select *
from 
    {{ semantic_layer.query(
    metrics = ['total_events'],
    group_by = [
        TimeDimension('metric_time', 'day'),
        Dimension('event_type__event_type_name'),
        Dimension('template__template_name')
    ]
) }}

SELECT
    DATE_TRUNC('day', event_time) AS metric_time,
    event_type.event_type_name,
    template.template_name,
    COUNT(*) AS total_events
FROM
    events_table AS events
JOIN
    event_type_table AS event_type ON events.event_type_id = event_type.id
JOIN
    template_table AS template ON events.template_id = template.id
GROUP BY
    1, 2, 3
ORDER BY
    1, 2, 3;