EcoResProductV2Entity
Products — the shared product master export (displayed as 'Products V2'), carrying product type, dimension-group assignments, and translated name and description
This entity is an export-shaped view over the tables below. When you land raw F&O tables instead of the entity, the SQL further down rebuilds it — joining the backing tables on their keys and DataAreaId. When to land tables vs entities
V2 product entity; CDM-confirmed (backing table EcoResProduct declared on the CDM entity page). OData collection name not verifiable from CDM — add publicCollectionName only if confirmed elsewhere.
Rebuild-from-tables SQL
Databricks SQLStarting point for reconstructing this entity from landed tables — the backing tables joined on their keys and DataAreaId. Set your Unity Catalog location, company, and filter values below.
2 parameters not filled: <catalog>, <schema>
-- ============================================================
-- Entity : EcoResProductV2Entity
-- Purpose: Rebuild EcoResProductV2Entity from landed F&O tables — auto-generated from table-entity-map
-- Grain : EcoResProduct × EcoResProductTranslation — 1:N joins yield one row per line
-- Tables : EcoResProduct, EcoResProductTranslation
-- Notes : Auto-generated skeleton for Synapse Link / Fabric Link-landed F&O data (lowercase column names). Enums decoded inline where verified; datetimes stored in UTC; 1900-01-01 dates are sentinels mapped to NULL. Company-partitioned tables are joined on DataAreaId to prevent cross-company fan-out. System/audit columns omitted — see the quirks guide.
-- ============================================================
SELECT
p.displayproductnumber AS "The product number shown to users; the natural key of the shared product",
p.searchname AS "Searchable short name for the product",
e.languageid AS "Language code of the translation; product + language is the natural key"
FROM <catalog>.<schema>.ecoresproduct p
LEFT JOIN <catalog>.<schema>.ecoresproducttranslation e
ON e.product = p.recid
ORDER BY p.displayproductnumber;Backing Tables
How these tables connect — join details in the list below.
Join details
ON ecoresproducttranslation.product = ecoresproduct.recid