大查询-从临时表创建表/视图
问题描述：
我们在Big Query中有一个查询，如下所示:
We have a query in Big Query like below
CREATE temp table ttt as (
SELECT * FROM TABLE
);
EXECUTE IMMEDIATE (
---Dynamic query goes here---
);
以上查询将结果存储在查询中所写的临时表中.如何将这些结果存储到实际的表/视图中，以便将其用于进一步的数据建模?
The above query is storing the results in a temporary table as written in the query. How to store these results into an actual table/view so that it can be utilized for further data modelling?
答
尝试使用:
EXECUTE IMMEDIATE (concat('create table dataset.table as ',---Dynamic query goes here---)
);