Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
JuliBaer
Contributor
Contributor

get data from a materialized view from google big query

Hi

is it possible to load data from a materialized view from google big query, or can only tables be loaded here?

We are already using the big query connector and can also load data from tables, but the materialized views are not visible in the "select data to load" window. Any ideas?

thx and best regards

Julian

Labels (2)
1 Reply
OpenPodBayDoor
Contributor
Contributor

Looking at the documentation regarding materialized views in the list of limitations the following appears: 

The data of a materialized view cannot be updated or manipulated directly using operations such as COPY, EXPORT, LOAD, WRITE, or data manipulation language (DML) statements.

Could this be the cause of the problem?