The Data Editor is a GUI tool to edit the live database. You don't have to use SQL queries with this tool; however, only those with advanced knowledge of SQL should have access.
There are risks when updating data directly in the database that include:
- Bypassing all field validation such as correct formatting and proper data values.
- Executing SQL statements using this tool bypasses DirectScale business logic. This can potentially put the data in a bad state, which can cause critical failures in any part of the DirectScale software.
- There is not an option to undo changes.
- Not all tables and columns are available to be edited for data integrity purposes.
Please use extreme caution when using this feature.
Updated about 1 year ago