# View: facts_prod_summary_sos

**View Name:** facts_prod_summary_sos
**Table Source:** `facts.prod.summary_sos`
**File Path:** `facts_prod_summary_sos.view.lkml`

## Overview

- **File Size:** 2771 bytes
- **Lines of Code:** 126
- **Dimensions:** 8
- **Measures:** 6
- **Dimension Groups:** 1
- **Filters:** 0

## Comments & Notes

- dimension: max_processed_timestamp_source {
- type: date_time
- sql: ${TABLE}.max_processed_timestamp_source ;;

## Dimensions

| Name | Type |
|------|------|
| `labelid` | number |
| `subaccountid` | number |
| `artistid` | number |
| `isrc` | string |
| `storeid` | number |
| `playlist_id` | string |
| `playlist_url` | string |
| `source_is_playlist` | yesno |

## Measures

| Name | Type |
|------|------|
| `streams_from_passive_discovery` | sum |
| `streams_from_active_discovery` | sum |
| `streams_from_collection` | sum |
| `overall_number_of_streams` | sum |
| `count_playlists` | count_distinct |
| `count_isrcs` | count_distinct |

## Dimension Groups

| Name | Type |
|------|------|
| `download_activity_date` | time |