# View: union_contact_alt_email_snowflake

**View Name:** union_contact_alt_email_snowflake
**Table Source:** `Derived from: Art_Relations_Prod_Art_Relations.Contact, Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Art_Relations_Prod_Art_Relations`
**File Path:** `union_contact_alt_email_snowflake.view.lkml`

## Overview

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

## Dimensions

| Name | Type |
|------|------|
| `contact_id` | number |
| `contact_email` | string |
| `is_alt` | string |

## Derived Table

```sql
sql:
          SELECT DISTINCT
            c1.contact_id,
            c1.contact_email,
            'N' AS is_alt
          FROM orchard_app_reporting_v2.art_relations_prod_art_relations.contact c1
          WHERE c1.contact_email IS NOT NULL
            AND c1.contact_email != ''

          UNION ALL

          SELECT DISTINCT
            c2.contact_id,
            c2.alt_email,
            'Y' AS is_alt
          FROM orchard_app_reporting_v2.art_relations_prod_art_relations.contact c2
          WHERE c2.alt_email IS NOT NULL
            AND c2.alt_email != ''
          ;;
```