#307 added support for reading BigQuery views by auto-materializing them into a temporary table before reading. That capability is currently exposed only through the DataStream API. The Table API / SQL path does not expose it, so a view referenced through SQL still fails the same way it did before #307.
Users should be able to use the connector in the following way,
CREATE TABLE my_view (
-- view's schema
) WITH (
'connector' = 'bigquery',
'project' = 'my-project',
'dataset' = 'my_dataset',
'table' = 'my_view',
'read.views.enabled' = 'true',
'read.views.materialization-project' = 'temp-project',
'read.views.materialization-dataset' = 'temp_dataset',
'read.views.materialization-expiration-hours' = '6',
'read.views.billing-project' = 'my-billing-project'
);
SELECT * FROM my_view;
#307 added support for reading BigQuery views by auto-materializing them into a temporary table before reading. That capability is currently exposed only through the DataStream API. The Table API / SQL path does not expose it, so a view referenced through SQL still fails the same way it did before #307.
Users should be able to use the connector in the following way,