# View: dt_mobile_users

**View Name:** dt_mobile_users
**Table Source:** `Derived from: Mobile_Orchard_Prod.Users, Mobile_Orchard_Prod_Android.Users, Segment_Events, Segment_Events.Mobile_Orchard_Prod, Segment_Events.Mobile_Orchard_Prod_Android + 1 more`
**File Path:** `dt_mobile_users.view.lkml`

## Overview

- **File Size:** 1257 bytes
- **Lines of Code:** 62
- **Dimensions:** 4
- **Measures:** 1
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `id` | string |
| `context_app_version` | string |
| `device_type` | string |
| `context_os_version` | string |

## Measures

| Name | Type |
|------|------|
| `count_id` | count_distinct |

## Derived Table

```sql
sql:
with users as (with users_unioned as (select TRIM(id, 'alw:') as id, context_app_version, 'Apple IOS' as device_type, context_os_version
from SEGMENT_EVENTS.MOBILE_ORCHARD_PROD.USERS

union all

select TRIM(id, 'alw:') as id, context_app_version, 'Android' as device_type, context_os_version
from SEGMENT_EVENTS.MOBILE_ORCHARD_PROD_ANDROID.USERS)

select distinct(id), device_type, context_os_version
from users_unioned)

select *
from users ;;
```