# View: dt_bits_per_sample

**View Name:** dt_bits_per_sample
**Table Source:** `INTELLIGENCE.DBT_PROD.BITS_PER_SAMPLE`
**File Path:** `dt_bits_per_sample.view.lkml`

## Overview

- **File Size:** 967 bytes
- **Lines of Code:** 33
- **Dimensions:** 2
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

- derived_table: {
- sql: WITH sample_rates AS (SELECT
- ald.bits_per_sample

## Dimensions

| Name | Type |
|------|------|
| `upc` | number |
| `bits_per_sample` | string |

## Derived Table

```sql
#    sql: WITH sample_rates AS (SELECT
#     a.upc,
#     ald.bits_per_sample
#FROM orchard_app_reporting_v2.reportsdd_direct_delivery.asset a
#INNER JOIN orchard_app_reporting_v2.reportsdd_direct_delivery.asset_location al ON al.asset_id=a.asset_id
#INNER JOIN orchard_app_reporting_v2.reportsdd_direct_delivery.asset_location_detail ald ON ald.asset_location_id=al.asset_location_id)
#
#SELECT
#    upc,
#    LISTAGG(DISTINCT bits_per_sample, '; ') WITHIN GROUP (ORDER BY bits_per_sample) AS bits_per_sample
#FROM sample_rates
#GROUP BY 1;;
#
```