Matched events

Events that are identified as usage for a product, are represented by matched events. From a modeling perspective, events right joined with products equate to matched events. Matched events are a view that can be found within the bframe schema. It is used to calculate usage.

Diagram

Table description

Column name	Data type	Description
transaction_id	VARCHAR	An identifier for looking up or referencing a specific event that occurred.
customer_id	VARCHAR	An identifier referencing a customer. Refers to customers.durable_id.
customer_alias	VARCHAR	An alternative identifier for the customer object to be used within metering.
properties	JSON	A JSON object that contains data about the event it is tied to.
metered_at	TIMESTAMP	A timestamp for when an event should be metered by the business system.
received_at	TIMESTAMP	A timestamp for when an event was logged by the system.
quantity	DECIMAL(18,3)	A decimal that refers to the number of products consumed or purchased.
product_uid	INTEGER	An identifier referencing a unique product row. Refers to product.id.
product_type	VARCHAR	A string that refers to the type of product ("FIXED", "EVENT", etc).