Supported Datasets and Models
Event Tables
Mitzu currently supports two main types of event tables in the data warehouse.
Single-event tables - tables that contain a single event type. Typical examples of this are
page_views
,click_events
tables. These tables have two mandatory columnsuser_id
andevent_time
(can be named differently)Multi-event tables - tables that contain multiple event types. The main difference between these tables and the single event tables is that these tables contain an
event_type
orevent_name
column in addition to theuser_id
andevent_time
. Typical examples for these tables areweb_events
,all_app_events
,subscription_events
, etc.
Modeling Event Properties
Single-event tables - typically, columns of these tables represent event properties.
Multi-event tables - most often, columns represent event properties. However, this leads to many missing column values if events don't support a certain event property. A more modern approach is to use a single column with a dynamic column type, such as json
and map.
Mitzu supports all the above-listed options. If your data model is not support please contact support@mitzu.io for help.
User Tables
User tables are tables that contain information about the users of the company. In these tables, every row represents a single user of the business. Each column in this table represents user properties.
Mitzu currently supports user tables.
Workspace Tables
Workspace tables are similar to user tables as they contain information about a workspace that users may work in. Workspace tables only make sense for businesses that support multi-workspace activity for their users. Each row in these tables represents a workspace for their users.
Mitzu currently doesn't support workspace tables.
Account Tables
Account tables are similar to user tables as they contain information about the company to which the users belong. These tables are most common for B2B companies. Each row represents an account the users belong to.
Mitzu currently doesn't support acount tables.
Last updated