maiven gateway · online··
manifest · 2d ago
Sign in Back to catalog
Definition
Products cleaned and re-keyed. Renames the SQL-reserved `name` column to `product_name`; otherwise a straight typed view of the catalog. The dimension every product-keyed mart joins to.
9 of 9
Column
Description
Tests · PII
product_id
Primary key — UInt64.
8 tests
sku
Stock-keeping unit code. Unique business identifier.
2 tests
product_name
Human-readable product name (renamed from `name` to avoid the SQL keyword).
category
Product category. Loose taxonomy; nullable.
unit_price
Catalog list price. Decimal(10,2).
2 tests
is_active
True if the product is currently sellable; false for archived/deleted entries.
source_created_at
Row insert timestamp from the source DB. DateTime64(6).
source_updated_at
Row update timestamp from the source DB. DateTime64(6).
airbyte_extracted_at
When Airbyte extracted this row from postgres-source.