date_trunc('week', SNAPSHOT_TIMESTAMP) as date,

count(DISTINCT REPO_OWNER) as developer,

count(DISTINCT REPO_NAME) as n_repository,

from near.core.fact_developer_activity

where date >= '2024-01-01'

group by 1