Event Tables
Event tables are tables in the data warehouse that contain user events. You must select specific columns for different purposes for each event table.
You can select a column for these purposes:
- User ID Column (mandatory): This column of the event table contains the User ID.
- Event time Column (mandatory): This column of the event table contains the event time.
- Group ID Column (optional): If your events have an attribute containing the ID of a set of users (e.g., groups, teams, organizations), you can configure this and enable group analytics.
- Event Name Column (optional): If your event table contains multiple events, you can set the column that distinguishes them.
- Date Partition Column (optional): Queries can take a long time on large tables, and to speed up the queries, some data warehouses support partitioning. You can configure the partitioning column if you've partitioned the table by the event time.
- Ignore Columns (optional): You can configure columns of the event table that you want Mitzu to ignore. Mitzu won't index these fields or list them on the Insights page.
List of the event tables​
You can browse the already configured and recently added event tables in a table showing all configured columns for each event table.
The content of this table list changes while you add, remove, or configure event data tables. It shows only the current state, and you must click on the Save and update event catalog button to persist your changes and index the updated tables.
Adding new event table(s)​
Click the Add tables button to open a new modal in which you can select the event tables to add.
The modal will load the available schemas of the configured data warehouse connection. Once the loading finishes, select the schema containing the event table(s) you want to add. After selecting the schema, Mitzu will load all table names in that schema. Once the tables are loaded, you can choose one or multiple tables to add. Click on the Add tables button to close the modal and add the new tables to the list of event tables. For further instructions, see the configure event tables section.
If you miss some tables from the list and you recently updated the connection settings or the Mitzu permissions in your data warehouse, click on the Refresh table list button to reload the list of tables in that schema.
Configure event tables​
Toggling the checkboxes in the list allows you to select one or more tables to configure. Then, click the Configure tables button to open a new modal.
You can select one or more columns for each input. Click on the Configure button to update the list of the event tables.
If you miss some columns from the lists and you recently updated the connection settings or the Mitzu permissions in your data warehouse, click on the Refresh table fields button to reload the list of tables in that schema.
You can select multiple values for each column. Mitzu will pick the first column existing in the event table. If a column does not exist in the event table and it is not a mandatory field, then Mitzu will leave that field blank.
You can double-check the configuration in the event table list, and if you are satisfied with it, then click on the Save and update event catalog button to persist your changes and to start indexing the updated tables.
Validate configation​
You can manually validate the saved or not yet saved event tables. First, select one or more event tables in the table by toggling the checkboxes and clicking on the Validate selected button to start the validation. Then, check the tables' existence, referenced columns, and their types if needed. You can track the progress and see the result below the table.
Re-indexing​
If the content of your table changes (e.g., a new event in a multi-event table, new event property columns, etc.), you need to re-index them. First, select one or more event tables in the table by toggling the checkboxes and clicking on the Re-index selected button to start the indexing. You can track the progress and see the result below the table. You can read more about this process on the indexing page.
Remove an event table​
You can remove an event table if you don't need it anymore.
First, select one or more event tables in the table by toggling the checkboxes and clicking on the Remove tables to remove them from the list. Then click the Save and update event catalog button to persist your changes.
All saved insights using an event from the removed event table will break.
Configure a schema​
If you want to add several event tables at once, first contact support at support@mitzu.io.
Add or modifiy a schema​
If you have several event tables, consider adding a schema that makes it easy to add multiple event tables at once if they follow the same column naming conventions.
First, open the Configure schema section by clicking on it. Here, you can see the list of stored schemas. The list contains the most recent changes; once you are satisfied with it, you must click on the Save schemas button to persist your changes.
To add a new schema, click on the Add schema button to open the modal where you can enter your schema's details.
First, select a schema in your data warehouse, then enter a regular expression for the table names. Mitzu will use this regular expression to find the tables you want to add; if the field is empty, then Mitzu will add all tables in the schema.
In the modal, similar to the configure event tables, you can enter the column names for the different fields. These are free text fields; you can enter only one column name for each field except for the Ignored columns field. You can enter multiple column names for the Ignored colums field by separating the values with a comma. Click on the Add schema button to close the modal, and you can see the added schema in the list. Click the Save schemas button to persist your changes.
To update a schema, toggle the checkbox in the table and click on the Configure schema button to open the same modal used to create the schema.
Common regular expressions are like
event_.*- selecting all tables with theevent_prefix.*_v2- selecting all tables ending with_v2
You can read more about regular expressions in this article.
Fetching schema​
To create event tables from a schema, select a schema by toggling the table's checkbox and clicking the Fetch schema button. It will list all the tables in the specified schema and filter them using the entered regular expression (or select all if the regular expression is empty). Then, Mitzu will create the event tables using the entered column names. You must check the configuration, and you may need to fix the column names if an event table does not follow the column naming conventions.
If satisfied, click the Save and update event catalog button.
Fetching will not update the already saved event tables, but it will add the removed event tables again if they still match the regular expression that was entered.