Re: Add pseudo columns to an existing view

Josh, I had looked through the documentation and all the tests (core/../end2end) on CREATE/ALTER VIEW usage. I could not find appropriate documentation around this. I am trying to ALTER VIEW as below and it doesn't seem to be supported. Here the STRVALUE

Re: Add pseudo columns to an existing view

Yes. Please see the docs which illustrate how to create views. On 7/28/20 2:12 AM, Arun J wrote: Team, Can we create or alter a view to add a column which is pseudo columns such as # FULLNAME from other columns such as FIRSTNAME + LASTNAME # NUMVALUE from other columns TO_NUMBER(STRVALUE)

Add pseudo columns to an existing view

Team, Can we create or alter a view to add a column which is pseudo columns such as # FULLNAME from other columns such as FIRSTNAME + LASTNAME # NUMVALUE from other columns TO_NUMBER(STRVALUE) This would be quite helpful to avoid changing data types everytime in the client query. Thanks in