Overview

Tables and fields can be added to the Staging Area so that this data can then be incorporated into the reporting tables further downstream. This article will cover how to add additional tables and fields to the Staging Area.

Details

Adding Tables and Fields

To add more tables and fields to the Staging Area, you will log in to the Cosmos Portal, navigate to the Data Model section, and check out your data model.

The first thing to do will be to click on the appropriate data source, if it isn't already selected, that you would like to bring in the tables and fields from. This will display all the tables and fields for the selected data source.

Next, in the Source Tables section you will find the tables that have already been added to the Staging Area. If you need to add a new table you can click the + button to the right of Source Tables, select the table(s) to be added, and click Add Selected Source Tables.

Once the tables have been added, you will see the new tables name in the Source Tables section on the left. You can expand the Fields section to see fields that are currently selected and click the + button to add additional fields.

These tables and fields are now available in the Transformations and Data Model areas of Cosmos so you can incorporate them into the overall data model.

Automatically Added Fields

Depending on the data source, some fields may be automatically checked when a table is added. For example, with Business Central data sources the "System ID" and "Modified At" fields are automatically checked and disabled, so they cannot be unchecked by the user. The reason for this is that Cosmos uses these when retrieving data from Business Central and the fields are required for the retrieval to work properly.

Fields that Cannot be Selected

You may notice some fields that are unchecked and disabled. These fields typically represent a small subset of data types that are not supported by Cosmos. For more details, please see the article here: Unsupported Business Central Field Types.