Create Table Models

In the Holistics's demo account, you will have access to the demo_database Data Source. This Data Source is a PostgreSQL database that contains several demo datasets in different schemas, and the data we will use for this tutorial is in the movies schema.

In Holistics, the first step to access the tables in your database is to create Table Models. Table Models are like views created on top that allow you to add more functionality to your physical tables without actually modifying them.

Table Model is one of the three types of Data Models in Holistics, along with Transform Model and Import Model.

  1. Navigate to the Data Modeling page

  2. Select the Data Source you have just created. The left panel will display a tree of existing folders and models in the data source.

  1. Navigate to a folder where you want to place your new models in, and click Create Data Model โ†’ Data Table:

    You can also click on the (+) button next to a folder name to open the menu

  2. Check the box next to the movies schema to select all tables available in this schema, and click Create.

    Table Models representing the tables in your database will be created. At the moment, Holistics will concatenate schema and table name to create Table Model's name:

  3. Add descriptions for the model and the fields

    To help your end-users understand the context of data, it is best to add descriptions to important fields, or change the default field label to make it clear.