I'm looking for a (desktop/web) application for users with no technical experiecne to update a column in a teradata table. I need a recurring function as there are multiple tables with same naming convention
Table 1: dbname.tbl_abc.cname1
If the user selects abc and enters few parameters, they should be able to update cname1 in dbname.tbl_abc.cname1
If the user selects bcdf and enters few parameters, they should be able to update cname1 in dbname.tbl_bcdf.cname1
Note: 1. Number of columns may vary from one table to another.
2. Unique identifier can be different from one table to another. For first table the granularity is dbname.tbl_abc.id1, for second it is dbname.tbl_bcdf.id1 and dbname.tbl_bcdf.id2