CODEWITHSUNDEEP
viewsnowflake-cloud-data-platform
user3150378
user3150378

Reputation: 345

Snowflake views

I have a view as below.

Create or replace view test as

With a as (

Select * from tblX )

B as (

Select * from thlY )

Select a.name , b.product

From a left join b on

a.Id = b.Id

Is it possible to get the value of either a or b from the above view? And if yes, how? Thanks.

Upvotes: 1

Views: 78

Answers (1)

patrick_at_snowflake
patrick_at_snowflake

Reputation: 453

CTEs are ephemeral views where as the create view statement is a permanent view. So if you don't want a or b in the output then don't include it.

Upvotes: 0

Related Questions