# View: int_dbt_prod_dt_vendor_icon

**View Name:** int_dbt_prod_dt_vendor_icon
**Table Source:** `INTELLIGENCE.DBT_PROD.DT_VENDOR_ICON`
**File Path:** `views/int_dbt_prod_dt_vendor_icon.view.lkml`

## Overview

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

## Comments & Notes

- Or, you could make this view a derived table, like this:
- derived_table: {
- 'https://images.theorchard.com/vendor/vendor_icon/' || path || filename AS img_path

## Dimensions

| Name | Type |
|------|------|
| `vendor_id` | number |
| `vendor_icon` | string |

## Derived Table

```sql
#     sql:
# SELECT
#     vendor_id,
#     'https://images.theorchard.com/vendor/vendor_icon/' || path || filename AS img_path
# FROM orchard_app_reporting_v2.art_relations_prod_art_relations.vendor_icon vi
# INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.image_assets ia ON vi.image_asset_id=ia.id
#       ;;
#
```