是否可以使用服务帐户在BigQuery中的“计划查询"中计划查询特征 ? [英] Is it possible to use service accounts to schedule queries in BigQuery "Schedule Query" feature ?

问题描述

我们正在使用BigQuery的Beta计划查询功能. 详细信息: https://cloud.google.com/bigquery/docs/scheduling-queries

We are using the Beta Scheduled query feature of BigQuery. Details: https://cloud.google.com/bigquery/docs/scheduling-queries

我们很少有隔夜运行的ETL计划查询，以优化聚合并降低查询成本.它运作良好，并且没有太多问题.

We have few ETL scheduled queries running overnight to optimize the aggregation and reduce query cost. It works well and there hasn't been much issues.

使用自己的凭据计划查询的人员离开组织时，就会出现问题.我知道在这种情况下我们可以进行更新凭证".

The problem arises when the person who scheduled the query using their own credentials leaves the organization. I know we can do "update credential" in such cases.

我通读了文档，还尝试了一下，但是找不到我们是否可以使用服务帐户而不是单个帐户来安排查询.

I read through the document and also gave it some try but couldn't really find if we can use a service account instead of individual accounts to schedule queries.

服务帐户更干净，并且可以与IAM框架的其余部分联系在一起，并且不依赖于单个用户.

Service accounts are cleaner and ties up to the rest of the IAM framework and is not dependent on a single user.

因此，如果您有有关预定查询和服务帐户的其他信息，请共享.

So if you have any additional information regarding scheduled queries and service account please share.

感谢您抽出时间阅读并回答问题.

Thanks for taking time to read the question and respond to it.

致谢

推荐答案

据我所知，很遗憾，您还不能使用服务帐户直接安排查询.也许一个Google员工会纠正我，但是BigQuery文档隐式声明了这一点:

As far as I know, unfortunately you can't use a service account to directly schedule queries yet. Maybe a Googler will correct me, but the BigQuery docs implicitly state this:

https://cloud.google.com/bigquery/docs/scheduling -queries#quotas

使用创建者的凭据执行计划的查询，并 项目，就好像您自己在执行查询一样

A scheduled query is executed with the creator's credentials and project, as if you were executing the query yourself

如果您需要使用服务帐户(这是BTW的最佳做法)，则列出了一些变通办法此处提出了一个FR.

If you need to use a service account (which is great practice BTW), then there are a few workarounds listed here. I've raised a FR here for posterity.

这篇关于是否可以使用服务帐户在BigQuery中的“计划查询"中计划查询特征 ?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！