Apply dev limits to dbt models

dev_limits.sql

-- Alternative one: Limit the result regardless of the query 

select *

from event_tracking.events

{% if target.name == 'dev' %}

limit 10

{% endif %}



-- Alternative 2: Limit the result depending on the loading date

select *

from event_tracking.events

{% if target.name == 'dev' %}

where created_at >= dateadd('day', -3, current_date)

{% endif %}