Skip to main content

Modifying a Custom Table

To modify a 'Custom Table' go to the 'Tables data structure' (Catalog > Data > Tables data structure)

Tables data structure

Select the table that you want to modify, then select 'Update'.

Update

This action will open a modal window.

modal window

You will be invited to download a definition file. It must be in the JSON format.

The following 'Custom Table' modifications are possible:

  • Adding an attribute (field)
  • Deleting an attribute
  • Adding a foreign key
  • Removing a foreign key
  • Making an attribute mandatory
  • Adding an index to an attribute
  • Adding accepted values to an attribute
  • Updating the creationTimeAttribute
  • Updating the valueAttribute
  • Updating the bigTable parameter
  • Updating the eventsToTrigger
  • Updating the cleaningRules
  • Updating the displayOptions

The JSON update file follows the exact structure as API calls.

You can follow the use case from the Developers Portal for examples of each operation.

Deleting a table​

You can delete both an empty or an already populated existing table.

Please proceed with caution: deleting a table can have a negative impact if the deleted table was used in scenarios, in campaign personalizations, in saved targetings, in segmentations,...

Unlike the above processes, deleting a table does not require uploading a JSON file. A dedicated 'Delete the table' option is available through the 'More' menu.

Deleting a table

A warning modal will require you to confirm the table deletion. Indeed, all the data stored in the table will be lost, without any option to restore it!

A warning modal

caution

If you delete an Interaction table linked to an aggregate table, the aggregate table will be deleted as well, as it cannot exist without a source.

Alt text

Downloading the definition of a table​

To make it easier to update the structure of a table, it is sometimes necessary to first verify it.

You can export it via the "Download Table Definition" button in the "More" menu. alt text

info

The first button retrieves the definition in the current format, which corresponds to the same JSON format used in the API.

The second button marked (Legacy feature) allows you to download the old format which was specific to the interface, but more complicated. This format will no longer be supported as of March 25 2025.

Tip

If you are downloading the definition of a table in order to create a new one, please note that the technical fields automatically created by Actito (id, creationMoment and updateMoment) must be deleted before you can re-import the JSON file.

Renaming a table​

Via the "More" menu, you can "Rename" a table.

alt text

This means changing its display name, as defined in the "diplayOptions".

The technical name of a table cannot be modified after creation.