Not sure whether this is expected behaviour, but dbReadTable() returns 0 rows when used on any view within the BigQuery environment. Using dbReadTable() with odbc on an MSSQL-database does return all rows when querying a view.