Via JSON
To modify a "Custom Table" go to the Tables structure (Catalog > Data > Tables data structure)
Select the table that you want to modify, then select "Update".
Then, click on "From JSON".
This action will open a modal window.
You will be invited to download a definition file. The following table modifications are possible:
- Adding an attribute (field)
- Deleting an attribute
- Adding a foreign key
- Removing a foreign key
- Making an attribute mandatory
- Making an attribute non mandatory
- Making an attribute unique
- Making an attribute non unique
- Adding an index to an attribute
- Removing an index from 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.
By clicking on "Edit source", you can edit the inserted JSON directly from the interface or even create it from scratch using the JSON editor (or paste it there).
Click on "Update" to launch the creation of the table. Any errors encountered during the update will be displayed, allowing you to fix the issues in the JSON.