# View: test

**View Name:** test
**Table Source:** `Derived Table (Custom SQL)`
**File Path:** `views/test.view.lkml`

## Overview

- **File Size:** 1092 bytes
- **Lines of Code:** 44
- **Dimensions:** 3
- **Measures:** 1
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `track_name` | string |
| `artist_name` | string |
| `stream_date` | date |

## Measures

| Name | Type |
|------|------|
| `streams` | sum |

## Derived Table

```sql
sql:
      SELECT 'Song A' AS track_name, 'Artist 1' AS artist_name, 1000 AS streams, '2024-11-01' AS stream_date
      UNION ALL
      SELECT 'Song B', 'Artist 2', 1500, '2024-11-02'
      UNION ALL
      SELECT 'Song C', 'Artist 1', 900, '2024-11-03'
      UNION ALL
      SELECT 'Song D', 'Artist 3', 2000, '2024-11-04'
      UNION ALL
      SELECT 'Song E', 'Artist 2', 1200, '2024-11-05'
      UNION ALL
      SELECT 'Song F', 'Artist 4', 800, '2024-11-06'
      UNION ALL
      SELECT 'Song G', 'Artist 3', 1700, '2024-11-07'
      UNION ALL
      SELECT 'Song H', 'Artist 5', 1100, '2024-11-08'
      UNION ALL
      SELECT 'Song I', 'Artist 1', 1300, '2024-11-09'
      UNION ALL
      SELECT 'Song J', 'Artist 4', 950, '2024-11-10';;
```