Mitzu is a no-code, warehouse-native product analytics application. Similar to tools like Amplitude, Mixpanel, and PostHog, Mitzu empowers users to analyze product usage data without requiring SQL or Python expertise. However, unlike these platforms, Mitzu doesn’t duplicate the company’s product usage data. Instead, it generates native SQL queries directly on the company’s existing data warehouse or lake.Documentation Index
Fetch the complete documentation index at: https://private-7c7dfe99-page-updates.mintlify.app/llms.txt
Use this file to discover all available pages before exploring further.
Goal
In this guide, we’re going to cover the following:- Warehouse-native product analytics
- How to integrate Mitzu to ClickHouse
- Gather your connection details
To connect to ClickHouse with HTTP(S) you need this information:
| Parameter(s) | Description |
|---|---|
HOST and PORT | Typically, the port is 8443 when using TLS or 8123 when not using TLS. |
DATABASE NAME | Out of the box, there is a database named default, use the name of the database that you want to connect to. |
USERNAME and PASSWORD | Out of the box, the username is default. Use the username appropriate for your use case. |
curl command.
If you’re using self-managed ClickHouse, the connection details are set by your ClickHouse administrator.
- Sign in or sign up to Mitzu
As a first step, head to https://app.mitzu.io to sign up.
- Configure your workspace
After creating an organization, follow the Set up your workspace onboarding guide in the left sidebar. Then, click on the Connect Mitzu with your data warehouse link.
- Connect Mitzu to ClickHouse
First, select ClickHouse as the connection type and set the connection details. Then, click the Test connection & Save button to save the settings.
- Configure event tables
Once the connection is saved, select the Event tables tab and click the Add table button. In the modal, select your database and the tables you want to add to Mitzu.
Use the checkboxes to select at least one table and click on the Configure table button. This will open a modal window where you can set the key columns for each table.
To run product analytics on your ClickHouse setup, you need to > specify a few key columns from your table. These are the following:
- User id - the column for the unique identifier for the users.
- Event time - the timestamp column of your events.
- Optional[Event name] - This column segments the events if the table contains multiple event types.
Once all tables are configured, click on the
Save & update event catalog button, and Mitzu will find all events and their properties from the above-defined table. This step may take up to a few minutes, depending on the size of your dataset.