# View: dt_sme_metadata_rows_by_day

**View Name:** dt_sme_metadata_rows_by_day
**Table Source:** `Derived from: Prod.Dim_Day, Prod.Staging_Sme_Product_Metadata_V2, Sme_Metadata_Rows_By_Day`
**File Path:** `dt_sme_metadata_rows_by_day.view.lkml`

## Overview

- **File Size:** 1397 bytes
- **Lines of Code:** 36
- **Dimensions:** 1
- **Measures:** 1
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `display_date` | date |

## Measures

| Name | Type |
|------|------|
| `rows` | sum |

## Derived Table

```sql
sql:  WITH sme_metadata_rows_by_day AS (SELECT
            (TO_CHAR(TO_DATE(facts_prod_dim_day.displaydate ), 'YYYY-MM-DD')) AS "displaydate",
            COALESCE(COUNT(sme_metadata.row_id), 0)  AS "rows"
        FROM facts.prod.dim_day  AS facts_prod_dim_day
        LEFT JOIN facts.prod.staging_sme_product_metadata_v2 sme_metadata  ON facts_prod_dim_day.displaydate = TO_DATE(sme_metadata.created_at)
        WHERE ((( facts_prod_dim_day.displaydate  ) >= ((DATEADD('day', -29, CURRENT_DATE()))) AND ( facts_prod_dim_day.displaydate  ) <=  CURRENT_DATE()
            AND sme_metadata.product_config_name != 'Digital Video Track' and LOWER(track_media_name)  = 'audio'
               ))
        GROUP BY
            (TO_DATE(facts_prod_dim_day.displaydate ))
        ORDER BY
            1
        FETCH NEXT 500 ROWS ONLY)
        SELECT
        (TO_CHAR(TO_DATE(sme_metadata_rows_by_day."displaydate" ), 'YYYY-MM-DD')) AS displaydate,
        COALESCE(SUM(sme_metadata_rows_by_day."rows"), 0) AS metadata_rows
    FROM sme_metadata_rows_by_day
    GROUP BY
        (TO_DATE(sme_metadata_rows_by_day."displaydate" ))
    ORDER BY
        1 DESC
    FETCH NEXT 500 ROWS ONLY;;
```