Skip to main content

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:

  • Identifier columns

    • User ID Column (mandatory): This column of the event table contains the User ID.
    • Entity ID columns: For all entities you've added on the Entities page, you can select the column containing the entity ID.
  • Event time columns

    • Event time Column (mandatory): This column of the event table contains the event time.
    • 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.
  • Other settings:

    • Event Name Column (optional): If your event table contains multiple events, you can set the column that distinguishes them.
    • 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.

warning

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.

image

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.

image

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.

warning

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.

image

You can select one or more columns for each input. Click on the Configure button to update the list of the event tables.

warning

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.

info

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.

warning

All saved insights using an event from the removed event table will break.