cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
cancel
Showing results for 
Search instead for 
Did you mean: 

Logic execute when we create an View?

Nhan_Nguyen
Valued Contributor

Hi all,

I have a small curious about VIEW on Databricks. Could anyone please help me clarify this?

Normal database like Postgres or MS SQL, when we define a view, the logic still not execute that time, only run when we query that VIEW.

Not sure how VIEW work on Databricks SQL?

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions

daniel_sahal
Honored Contributor III

@Nhan Nguyen​ 

It works the same. CREATE VIEW constructs a virtual table that has no physical data.

View solution in original post

1 REPLY 1

daniel_sahal
Honored Contributor III

@Nhan Nguyen​ 

It works the same. CREATE VIEW constructs a virtual table that has no physical data.

Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.