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): the column of the event table that contains the user ID.
  • Entity ID columns: for each entity you've added on the Entities page, you can select the column that contains the entity ID.

• Event time columns

  • Event time Column (mandatory): the column of the event table that contains the event time.
  • Date Partition Column (optional): queries can take a long time on large tables. To speed them up, some data warehouses support partitioning. If you've partitioned the table by event time, configure the partitioning column here.

• Other settings

  • Event Name Column (optional): if your event table contains multiple events, 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 or list these fields on the Insights page.

List of event tables

You can browse the already configured and recently added event tables in a table that shows all configured columns for each event table.

warning

The content of this list changes as you add, remove, or configure event data tables. It only shows the current state, and you must click the Save button to persist your changes and index the updated tables.

Adding new event table(s)

Click the Add event tables button to open a modal where you can select the event tables to add.

First, select the appropriate tab. If each event table contains only a single event, choose Single event table. If the event tables contain multiple events distinguished by a column containing the event name, choose Multi event table.

The modal loads the available schemas from the configured data warehouse connection. Once loading finishes, select the schema containing the event table(s) you want to add. After you pick a schema, Mitzu loads every table name in it. You can then choose one or more tables to add, or pick - ADD ALL <N> TABLES - to select them all (where <N> is the number of tables in the schema).

Once the tables are selected, you can configure the fields for:

• User ID column (mandatory)
• Event time column (mandatory)
• Date partition column (optional)
• Event name column (visible and mandatory only on the Multi event table tab)

For each column, type the column name and select it from the dropdown. If you're unsure what columns are available, click the Fetch columns button. It loads the available columns for all selected tables and populates the dropdown fields with the most common column names.

warning

Fetching columns can take a long time if too many tables are selected.

Click the Add tables button to close the modal and add the new tables with the selected fields.

warning

If some tables are missing from the list and you recently updated the connection settings or the Mitzu permissions in your data warehouse, click the refresh button next to the tables dropdown to reload the list of tables in that schema.

Configure event tables

Toggle the checkboxes in the list to select one or more tables to configure, then click the Configure tables button to open a new modal.

For each column, type the column name and select it from the dropdown. If you're unsure what columns are available, click the Fetch columns button. It loads the available columns for all selected tables and populates the dropdown fields with the most common column names.

warning

Fetching columns can take a long time if too many tables are selected.

Click the Configure button to update the list of event tables.

warning

Newly added and reconfigured event tables are not indexed automatically. You need to select them and click the Index selected button to index them.

Enable / Disable

You can disable a table if you don't want to use it as an event table. To do so, toggle the checkbox of an event table and click the Enable / Disable button.

warning

When a table is disabled, all events and catalog records belonging to that table are removed.

Re-indexing

If the content of your table changes (for example, a new event in a multi-event table, new event property columns, etc.), you need to re-index it. First, select one or more event tables by toggling the checkboxes, then click the Re-index selected button to start 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 no longer need it.

warning

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