view: dt_days_since_release {
  # Or, you could make this view a derived table, like this:
  derived_table: {
    sql:
SELECT
    t.trackname,
    t.isrc,
    MIN(r.sale_start_date) AS lower_bound,
    DATE_FROM_PARTS(YEAR(lower_bound), MONTH(lower_bound),DAY(lower_bound)) AS lower_date,
    DATEADD(day,{% parameter days_since_sales_start %},lower_bound) AS upper_bound,
    DATE_FROM_PARTS(YEAR(upper_bound), MONTH(upper_bound),DAY(upper_bound)) AS upper_date
FROM facts.prod.dim_release r
INNER JOIN facts.prod.dim_track t ON t.upc=r.releaseid
WHERE t.isrc= {% parameter isrc_dsr %}
GROUP BY 1,2
      ;;
  }

  dimension:lower_date {
    type: date
    hidden: yes
    sql: ${TABLE}.lower_date ;;
  }

  dimension:upper_date {
    type: date
    hidden: yes
    sql: ${TABLE}.upper_date ;;
  }

parameter: isrc_dsr {
  type: string
}

parameter: days_since_sales_start {
  type: number
}

}