topic Re: get data from a materialized view from google big query in Data Movement & Streaming

get data from a materialized view from google big query

JuliBaer — Wed, 19 Mar 2025 21:58:43 GMT

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

Re: get data from a materialized view from google big query

OpenPodBayDoor — Tue, 16 Jul 2024 13:08:53 GMT

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?

Re: get data from a materialized view from google big query

JuliBaer — Tue, 23 Jul 2024 04:09:50 GMT

Hi, thanks for your answer.

I don't know if that could be the reason.
But I found out that I can access the MV via SQL query. But it is still not displayed as an available table in the wizard.