Logic execute when we create an View?

[Nhan_Nguyen]

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

[daniel_sahal · Accepted solution]

@Nhan Nguyen​ 

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