# View: dt_subaccount_contact

**View Name:** dt_subaccount_contact_details
**Table Source:** `Derived from: Art_Relations_Prod_Art_Relations.Contact, Art_Relations_Prod_Art_Relations.Subaccount, Art_Relations_Prod_Art_Relations.Vend_Contact, Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Art_Relations_Prod_Art_Relations`
**File Path:** `dt_subaccount_contact.view.lkml`

## Overview

- **File Size:** 2044 bytes
- **Lines of Code:** 67
- **Dimensions:** 6
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `s_subaccount_id` | number |
| `subaccount_name` | string |
| `split_type` | string |
| `full_name` | string |
| `contact_email` | string |
| `address_country` | string |

## Derived Table

```sql
sql:
      SELECT
          s.subaccount_id AS s_subaccount_id,
          s.subaccount_name AS subaccount_name,
          s.subaccount_split_type AS split_type,
          vc.contact_id AS vc_contact_id,
          c.contact_first_name AS contact_first_name,
          c.contact_last_name AS contact_last_name,
          c.contact_email AS contact_email,
          c.orchard_country AS address_country
      FROM ORCHARD_APP_REPORTING_V2.ART_RELATIONS_PROD_ART_RELATIONS.SUBACCOUNT AS s
      LEFT JOIN ORCHARD_APP_REPORTING_V2.ART_RELATIONS_PROD_ART_RELATIONS.VEND_CONTACT AS vc
          ON vc.subaccount_id = s.subaccount_id
      LEFT JOIN ORCHARD_APP_REPORTING_V2.ART_RELATIONS_PROD_ART_RELATIONS.CONTACT AS c
          ON c.contact_id = vc.contact_id
      ;;
```