1
votes

I am interested in using a view to limit access to only certain partitions of a table. Should I expect to see decreased performance when selecting from the view as opposed to selecting from the table directly (slower response times or higher data usage)? Does the data essentially have to be selected twice?

View Query:

SELECT 
     *

FROM 
     project:dataset.table 

WHERE 
     _PARTITIONTIME between DATE_ADD(CURRENT_TIMESTAMP(), -1, "MONTH") and CURRENT_TIMESTAMP()
1

1 Answers

5
votes

It's the same performance characteristics either way. You can imagine that a reference to a view is equivalent to inlining the SQL text into the rest of the query.