# View: dt_season_start_date_podcast

**View Name:** dt_season_start_date_podcast
**Table Source:** `Derived from: Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Prod_Ows_Podcast_Ows_Podcast, Prod_Ows_Podcast_Ows_Podcast.Episode, Prod_Ows_Podcast_Ows_Podcast.Podcast`
**File Path:** `dt_season_start_date_podcast.view.lkml`

## Overview

- **File Size:** 760 bytes
- **Lines of Code:** 33
- **Dimensions:** 3
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

- dimension: episode_id {
- type: number
- primary_key: yes

## Dimensions

| Name | Type |
|------|------|
| `podcast_id` | number |
| `season_number` | number |
| `season_start_date` | date |

## Derived Table

```sql
sql:
  Select e.podcast_id, p.title, e.season_number, min(e.published_Date) as season_start_date
from ORCHARD_APP_REPORTING_V2.PROD_OWS_PODCAST_OWS_PODCAST.EPISODE e
inner join ORCHARD_APP_REPORTING_V2.PROD_OWS_PODCAST_OWS_PODCAST.PODCAST p on e.podcast_id = p.id
where season_number is not null  and e.episode_number = 1
group by 1,2,3
order by 1,3;;
```