default_simulation.sql

SELECT
  lease_dim_id,
  reporting_month AS simulated_default_month
FROM
(
  -- 
  SELECT
      *,
      ROW_NUMBER() OVER(PARTITION BY certificate_dim_id ORDER BY (RANDOM() * COALESCE(perc_losses_expected+in_month,0)) DESC) AS rnk
  FROM ll_fact_lease_ts ts
  LEFT JOIN ll_dim_unit_econ_curves ue ON
  (
      ue.months_into_term = DATEDIFF('months', move_in_date, reporting_month)
  )
)
where rnk = 1