CODEWITHSUNDEEP
analyticsgoogle-bigquery
Ashish
Ashish

Reputation: 45

Making View in Big Query is good practice?

I am making View in Big Query but if am running any query again on this View it says this query will process the same GB space as of the table whose Desired View is created

Does View Destroyed Automatically or we have to delete it?

Upvotes: 2

Views: 1432

Answers (2)

Segah Meer
Segah Meer

Reputation: 63

Database views are immaterial. If you are looking for a logical layer, you are almost always better off doing the modeling in a tool such as Looker or Microstrategy, where you can document the view logic as well: https://discourse.looker.com/t/how-to-reference-views-and-fields-in-lookml/179

Upvotes: 0

Felipe Hoffa
Felipe Hoffa

Reputation: 59325

Views act in a similar way to macros: They auto-expand at execution time.

Storing a view processes no data: It just stores the associated query with a name you can use later.

When using a view in a larger query it will process data online: BigQuery has no materialized views (yet).

Upvotes: 1

Related Questions