# View: mkt_program_info_snowflake

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

## Overview

- **File Size:** 2730 bytes
- **Lines of Code:** 146
- **Dimensions:** 18
- **Measures:** 0
- **Dimension Groups:** 1
- **Filters:** 0

## Comments & Notes

- set: detail {
- mkt_program_info_id,
- mkt_program_id,

## Dimensions

| Name | Type |
|------|------|
| `mkt_program_info_id` | number |
| `mkt_program_id` | number |
| `info_for` | string |
| `info_for_id` | string |
| `subject` | string |
| `description` | string |
| `project_highlights` | string |
| `description_drivers` | string |
| `description_blurb` | string |
| `description_highlights` | string |
| `lyrics` | string |
| `contains_lyrics` | yesno |
| `attachment` | string |
| `attachment_link` | string |
| `date_added` | date_time |
| `last_updated` | date_time |
| `scope` | string |
| `client` | string |

## Dimension Groups

| Name | Type |
|------|------|
| `lyrics_date_added` | time |

## Derived Table

```sql
sql:
   select
      mkt_program_info_id,
      mkt_program_id,
      info_for,
      info_for_id,
      subject,
      date_added,
      last_updated,
      attachment,
      scope,
      client,
      listagg(distinct REGEXP_REPLACE(description,'(<[^>]+?>|&nbsp;)'), ' . ') as description
      from  orchard_app_reporting_v2.art_relations_prod_art_relations.mkt_program_info
   group by 1,2,3,4,5,6,7,8,9,10;;
```