# View: ORCHARD_APP_REPORTING_V2.PROD_OWS_TRACK_OWS_TRACK.PERFORMER_ROLE

**View Name:** orchard_app_reporting_v2_prod_ows_track_ows_track_performer_role
**Table Source:** `ORCHARD_APP_REPORTING_V2.PROD_OWS_TRACK_OWS_TRACK.PERFORMER_ROLE`
**File Path:** `ORCHARD_APP_REPORTING_V2.PROD_OWS_TRACK_OWS_TRACK.PERFORMER_ROLE.view.lkml`

## Overview

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

## Comments & Notes

- dimension: Performer_role_id {
- # You can specify the table name if it's different from the view name:
- sql_table_name: my_schema_name.tester ;;

## Dimensions

| Name | Type |
|------|------|
| `Performer_role_id` | number |
| `Performer_Role` | string |
| `Creation_Date` | date |

## Derived Table

```sql
#     sql: SELECT
#         user_id as user_id
#         , COUNT(*) as lifetime_orders
#         , MAX(orders.created_at) as most_recent_purchase_at
#       FROM orders
#       GROUP BY user_id
#       ;;
#
```