Add Tables or Views

In the Data Model Designer, you can add tables or views from the associated data source to your data model. The list of available tables and views depends on the data source configuration. Tables provide raw transactional or master data directly from the database, while views offer data that has already been aggregated, joined, or filtered using SQL logic.

Every data model has a fact table, which is the starting point for queries. Records from the fact table are always returned, even if there are no matching records in linked tables. By default, the first table you add is set as the fact table, but you can change it if needed.

note

Make sure the Design Graph is visible by hovering over View and selecting Design Graph.

Add a table

1. On the Insert tab, select Add Table.
   Or right-click in the Design Graph and click Add Table.
2. Use the search bar to find your table.
3. Double-click the table you want to add. It appears in the Design Graph.
4. Add more tables as needed.
5. Close the dialog when finished.
6. On the File tab, click Save Data Model.

Column properties

Column	Description
Name	Table or view name from the data source.
Description	Description of the table or view (if available in the source).
Schema	Schema name where the table or view resides.
Type	Type of the object, either Base table or View.

Choose the fact table

1. In the Design Graph, select the table you want as fact table.
2. Right-click the table header and select Set Fact Table.
3. On the File tab, click Save Data Model.

Preview data

Previewing data helps you verify the table contains and values you expect.

1. In the Design Graph, select a table.
2. Right-click the table header and select Preview Data.
3. Review the displayed records. Only the first 1,000 rows of the table are shown.
4. Close the dialog when finished.

Delete a table

1. In the Design Graph, select the table you want to delete.
2. Right-click the table header and select Remove Table.
3. On the File tab, click Save Data Model.