Product

Table name (referenced in Insights SQL queries): marts_mdc__product

Product master data mart with one row per product, consolidating core product info, handling units, HS codes by region, barcodes, attributes, and integration custom data.

Columns

Column	Type	Description
product_id	number	Unique identifier of the product.
account_id	number	Identifier for the account associated with this product.
account_name	varchar	Name of the account.
sku	varchar	Product SKU.
product_name	varchar	Product display name.
is_product_active	boolean	Whether the product is active.
product_type	varchar	Type of the product.
product_replacement_value_usd	float	Replacement cost in USD given latest conversion rates.
product_replacement_value	float	Replacement cost amount in the original currency.
product_replacement_value_currency	varchar	Currency code for the replacement cost (e.g. USD).
country_of_origin_code	varchar	2-letter ISO country code of origin.
product_created_at_utc	timestamp_ntz	Timestamp when the product was created (UTC).
product_updated_at_utc	timestamp_ntz	Timestamp when the product was last updated (UTC).
product_weight_lb	float	Product weight in pounds.
product_length_in	float	Product length in inches.
product_width_in	float	Product width in inches.
product_height_in	float	Product height in inches.
hs_code_us	varchar	Harmonized System code for the US region.
hs_code_uk	varchar	Harmonized System code for the UK region.
hs_code_eu	varchar	Harmonized System code for the EU region.
inner_carton_count	number	Number of product units per inner carton.
inner_carton_weight_lb	float	Inner carton weight in pounds.
inner_carton_length_in	float	Inner carton length in inches.
inner_carton_width_in	float	Inner carton width in inches.
inner_carton_height_in	float	Inner carton height in inches.
master_carton_count	number	Number of product units per master carton.
master_carton_weight_lb	float	Master carton weight in pounds.
master_carton_length_in	float	Master carton length in inches.
master_carton_width_in	float	Master carton width in inches.
master_carton_height_in	float	Master carton height in inches.
pallet_count	number	Number of product units per pallet.
pallet_weight_lb	float	Pallet weight in pounds.
pallet_length_in	float	Pallet length in inches.
pallet_width_in	float	Pallet width in inches.
pallet_height_in	float	Pallet height in inches.
product_barcodes_list	varchar	JSON array of barcode strings associated with the product.
product_attributes	varchar	JSON object with active product attributes as key-value pairs.
product_custom_data	varchar	JSON object containing integration-specific custom attributes for the product.