Quick Preview of Multi-Table Join Feature

Quick Start

Viewing the following video might be more intuitive.

Test Database MySQL

Provides read-only MySQL user information and comes pre-loaded with datasets from Kaggle (opens in a new tab) for Join analysis.

host: tpe0.clusters.zeabur.com
port: 31228
user: readonly_user
password: k6stestpw
database: kanaries_test

Create Datasource

Navigate to: https://kanaries.net/analytics/new?template=Mysql (opens in a new tab) and complete the data source creation with the aforementioned test information.

Create Dataset

If the data source is successfully created, you will arrive at the data set creation page, where you can freely create data sets using SQL. For example, by using 'select _ from olist_orders_dataset' and 'select _ from olist_customers_dataset', you can create two data sets named 'olist_orders_dataset' and 'olist_customers_dataset' respectively.

Alternatively, you can use the quick import feature to directly convert your table into a dataset.

Join Dataset

When you open the analysis page of the 'olist_orders_dataset' table, you will notice a 'Join' button at the top right corner. Clicking on it allows you to select data sets from the same data source. If everything goes smoothly, you should be able to see the 'olist_customers_dataset'.

Continuing on, in the sidebar, you will see "Unlink datasets", which prompts you to configure link information for them. Note: The configuration here will not modify your database; it's merely an association relationship.

For example, the 'customerid' in these two tables can be used as the linking relationship. Once the relationship is confirmed, you can freely perform multi-table JOIN analysis.