Re: Add pseudo columns to an existing view

[Arun J]

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 is one of column in the original View.  Appreciate any
pointers.

ALTER VIEW MY_VIEW_NAME ADD NUMVALUE DECIMAL TO_NUMBER(STRVALUE)


On Fri, Jul 31, 2020 at 7:53 PM Josh Elser  wrote:

> 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)
> >
> > This would be quite helpful to avoid changing data types everytime in
> > the client query.
> >
> > Thanks in advance.
> > JAK
>

Re: Add pseudo columns to an existing view

[Josh Elser]

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)

This would be quite helpful to avoid changing data types everytime in 
the client query.


Thanks in advance.
JAK

Add pseudo columns to an existing view

[Arun J]

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 advance.
JAK