Create a custom table

About custom tables

You can create a custom table from a source data table to define and edit the columns that you want to work with. All your custom tables will appear as common data tables in the finder.

For example, this may be useful when you send data to the Devo platform from a source that has not a tag defined yet. In this case, your raw data will be stored in a my.app table. You can query the necessary data and create a custom table only with the required columns.

What permissions do I need?

To use this feature you need two different permissions:

• View level of the Finders permission. This permission is required to access a search, which is necessary to create a custom table.

• The Custom tables permission. This permission is required to enable the custom table options in the toolbar menu of the search window.

Open

Creating your custom table

To define a new custom table, go to Data search and open the data table you want to use as the base for your custom table. Select the options menu in the right-hand side of the toolbar, then go to New → Custom table → New.

You will see the Custom table window, where you can do the following:

Open

1. Give the custom table a name. Choose either my.synthesis, my.tech or my.parser, then enter the third and fourth levels of the table name. Note that the table name must contain at least one alphanumeric character and not contain spaces or special characters (underscores are allowed).

2. Check this option if you want to include raw and rawMessage fields in your custom table. These fields are not shown by default in tables. See more information about unrevealed fields in this article.

3. Select New field to add new fields to the custom table.

4. Configure the custom table fields. You can edit the source table names and the values they show.

5. You can edit the columns' values and names or delete them.

6. Click Create when you are done.

Accessing your custom table

The new custom table will appear in Data search → Explore your data.