Teradata Studio Express: data editing from Views

Teradata Studio

Teradata Studio Express: data editing from Views

When using TSE 15.10.01, it does not seem possible to edit data from a View.

Of course, Table Data Editor is working perfectly well with Tables. But is there a reason why data editing from View is not allowed ?

Thanks

5 REPLIES
Teradata Employee

Re: Teradata Studio Express: data editing from Views

Vincent, This is a restriction in Teradata.  Most likely because the data actually resides in the table, not the view.

Teradata Employee

Re: Teradata Studio Express: data editing from Views

Views of a single table with 1:1 correspondence between view columns and table columns may be updatable. In other words, you can use views to limit update access to specific rows and columns. But more complex views with joins, aggregation, derived column expressions, etc. are not updatable.

Teradata Employee

Re: Teradata Studio Express: data editing from Views

Studio currently does not provide the option for Views. If we can easily determine whether the view is 'updateable' without having to parse the View SQL, we should be able to add this. It is something we can look into. 

Re: Teradata Studio Express: data editing from Views

Hello Francine,

From your last reply, I'm assuming Teradata might be willing to look into this feature. What would be the right way to formalise this request ? Should we open an incident under TaYS ?

Data Editing would definitely be a welcome addition to us since our access rights are usually granted on Views (as it is the recommended way to secure data access) and our Users mostly work with Views.

Thanks kindly

Vincent

Teradata Employee

Re: Teradata Studio Express: data editing from Views

Vincent, Yes, please go through T@YS and request an RFC. Thanks.