Generate data models

In this step, you will generate data models using the connected data source from the last step.

Cube's data models provide a declarative way to define important facts about your data and relationships between them. You can create data models from scratch or let Cube generate an initial version for you.

Select tables

Start by selecting the database tables to generate the data models from, then click Measures and Dimensions:

Measures and dimensions

Next, you'll see all detected measures and dimensions from the data source. Click Primary Keys to progress to the next step:

Primary keys

Review the detected primary keys for each cube and click Joins to move to the next step:

Joins

Once again, review the detected joins and relationships and click Review:

Review

The last screen allows you to review all the detected cubes and their corresponding measures, dimensions, and joins. If everything looks good, pick either YAML (recommended) or JavaScript format and click Confirm & Generate:

Cube Cloud will now generate the models and spin up your Cube deployment, and in a few moments you should see the following screen:

You're now ready for the next step, querying the data.