# View: contact_snowflake

**View Name:** contact_snowflake
**Table Source:** `orchard_app_reporting_v2.art_relations_prod_art_relations.contact`
**File Path:** `contact_snowflake.view.lkml`

## Overview

- **File Size:** 6212 bytes
- **Lines of Code:** 249
- **Dimensions:** 30
- **Measures:** 1
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

- TEMPORARY - REMOVE WHEN `ORCHARD_STATE` IS AVAILABLE IN SNOWFLAKE

## Dimensions

| Name | Type |
|------|------|
| `contact_first_name` | string |
| `contact_middle_name` | string |
| `contact_last_name` | string |
| `contact_full_name` | string |
| `contact_email` | string |
| `contact_affiliation` | string |
| `alt_email` | string |
| `contact_comment` | string |
| `contact_id` | number |
| `contact_title` | string |
| `affiliation_id` | number |
| `address_street` | string |
| `address_city` | string |
| `address_zip` | string |
| `address_state` | string |
| `contact_fax` | string |
| `contact_cell` | string |
| `contact_phone` | string |
| `contact_phone_2` | string |
| `checks_remove` | string |
| `company` | string |
| `instrument` | string |
| `address2` | string |
| `country` | string |
| `orchard_country` | number |
| `address_other_state` | string |
| `contact_type` | string |
| `send_option` | string |
| `address_last_updated` | string |
| `state_abbr` | string |

## Measures

| Name | Type |
|------|------|
| `count` | count |