# Creating an Elasticube Insights Model in TD Console

An Insights model is the data source for Treasure Insights. By defining relationships between tables, you can build dashboards and widgets that analyze your data.

* [Limitations](#limitations)
* [Create an Insights Model](#create-an-insights-model)
* [Define the Insights Model](#define-the-insights-model)
* [Add Data](#add-data)
* [Define Data Connections](#define-data-connections)


## Limitations

* Support for an Elasticube with Treasure Data Plazma tables that has existing columns; no support to extract columns via SQL.
* No support for custom columns and tables.
* No error log details.
* You cannot change the data model's name.


## Create an Insights Model

There are five steps to build and share an Insights model.

![](/assets/image2023-2-27_10-31-8.5a68c211e66b6a75eb8607d2207294cc5426c5f7ad039910e2becdff717866be.b979d678.png)

## Define the Insights Model

You must have the ability to edit data models and dashboards to define an Insights model.
Currently, it's not possible to use the same name tables even if they are under different databases. For example, if you have database_a.table1 and database_b.table1, you can't save them into the same datamodel. Please consider renaming one of the tables in such cases.

1. Open TD Console.
2. Select the Treasure Data icon to open the console.
![](/assets/crystal_console_screenshot.e3e479de6a6963660af0005ccf6f540408c4ecc28b4df3a6fbd225a6478220bf.b979d678.png)
3. Navigate to **Control Panel** > **Settings**.
4. Select **Insights Models** and then select**Create Insights Model**.


![](/assets/image2021-3-23_11-44-38.ddcf9de82ea4ad5d95fd900cc03f95bb0db5b46ce31fccddc5247df8ab7b6ab0.b979d678.png)

1. Complete the required fields:


* **Name** : Provide a meaningful name for your Insights model. You cannot change the name after you create the model.
* **Type** : Select ElastiCube
* **API Key** : Enter your Master [API Key](/products/my-settings/getting-your-api-keys).


![](/assets/image2023-3-2_14-21-55.e1dcbaf6227e4304d0ba652dc71f7e704b8bba9afb487b1067deeee876a08d92.b979d678.png)

1. (Recommended) Enter a description for the Insights model.
2. Select **Create**.


## Add Data

Add data to your "empty" Insights model. First, you identify a database and then add tables to the data model.

1. Select**Add data**.

2. Search for and select a database.

3. Select one or more tables and add them to your data model.

| ![Success](/assets/success.af604206e136e6b09d9e959f81cf569a779fa0a394aa8aa6f99dacf02b493a21.b979d678.png) | If you have tables with long names, hover your mouse over the name to display the full name. |
|  --- | --- |


![](/assets/image2021-3-24_10-16-57.b849591106ece3832ba999ad22885db8127493f53a1871d5c4433c5584c11673.b979d678.png)

## Define Data Connections

1. Connect data from one table to data in another table.

2. Select column data and a data type.

![](/assets/image2021-3-29_15-4-58.5de577e0485817cb08ac9a3df48f9a04cba287bf962a04aacd8edefec6b97b89.b979d678.png)

3. Drag the arrow to connect the data.
Data types that match your selected data type display with connection dots. If there is a column with the same name, it's highlighted in blue. In the following example, we connect the table dls_sales, column email to table e-commerce sales, column email.

![](/assets/image2021-3-29_15-36-36.df338c4c3a1f15ece8e09c643d486ff6773ca0cbd88a4edbc28f6427f218a7f5.b979d678.png)

4. Switch tables and connect dlc_sales, column email to e-commerce_sales, column email.

![](/assets/image2021-3-29_16-3-4.aba71db7192d949d04231949237531f5f40fb58761f9ef4676357850d28d72b9.b979d678.png)

5. Save your Insights model.

### Next Steps

[Building an Elasticube Insights Model](/products/customer-data-platform/treasure-insights/building-an-elasticube-insights-model)

[Sharing ElastiCube Insights Models](/products/customer-data-platform/treasure-insights/sharing-elasticube-insights-models)