# View: dt_abacus_profiles

**View Name:** dt_abacus_profiles
**Table Source:** `Derived from: Prod.Has_Profile`
**File Path:** `views/dt_abacus_profiles.view.lkml`

## Overview

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

## Dimensions

| Name | Type |
|------|------|
| `identity_id` | string |
| `profile_uuid` | string |
| `profile_id` | string |
| `profile_name` | string |
| `profile_type` | string |
| `roles` | string |
| `updated_by` | string |
| `updated_on` | date_time |
| `language` | string |
| `created_at` | string |
| `last_modified_at` | string |
| `last_modified_by` | string |
| `created_by` | string |

## Derived Table

```sql
sql:
      select
        r.identity_id,
        r.profile_uuid,
        p.profile_id,
        p.profile_name,
        p.profile_type,
        p.roles,
        p.language,
        p.updated_by,
        p.updated_on,
        p.created_at,
        p.last_modified_at,
        p.last_modified_by,
        p.created_by
      from facts.prod.profile p
      inner join facts.prod.has_profile r on  p.uuid = r.profile_uuid
      where p.profile_type = 'AbacusProfile' ;;
```