如何在气流中使用BigQueryOperator创建视图?

本文介绍了如何在气流中使用BigQueryOperator创建视图?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

来自GCP文档: cloud.google/bigquery/docs/views他们使用BQ API创建视图的说明是使用包含视图属性的表资源调用table.insert方法."

From GCP docs: cloud.google/bigquery/docs/views their instructions for creating a view using the BQ API is "Call the tables.insert method with a table resource that contains a view property."

有人知道如何通过气流的BigQueryOperator做到这一点吗?还是我应该再找一个操作员?

Any idea how to do this via airflow's BigQueryOperator? Or is there another operator I should us?

推荐答案

只需使用DDL的创建VIEW语句为

{CREATE VIEW | CREATE VIEW IF NOT EXISTS | CREATE OR REPLACE VIEW} view_name [OPTIONS(view_option_list)] AS query_expression