Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

need bigquery.jobs.create permission in kubernetes-public #2729

Closed
deads2k opened this issue Sep 15, 2021 · 6 comments · Fixed by #2744
Closed

need bigquery.jobs.create permission in kubernetes-public #2729

deads2k opened this issue Sep 15, 2021 · 6 comments · Fixed by #2744
Assignees
@spiffxp
Labels
area/access Define who has access to what via IAM bindings, role bindings, policy, etc. kind/bug Categorizes issue or PR as related to a bug. priority/important-soon Must be staffed and worked on either currently, or very soon, ideally in time for the next release. sig/architecture Categorizes an issue or PR as relevant to SIG Architecture.
Milestone
v1.23

Comments

@deads2k
Copy link
Contributor

deads2k commented Sep 15, 2021 •
edited
Loading

While working with the PRR survey results (thanks for handling #2619), I tried to run come queries and got back an error that says

Access Denied: Project kubernetes-public: User does not have bigquery.jobs.create permission in project kubernetes-public.

The query I attempted to run is

select 
  concat("select ", string_agg(concat(raw_column_name, " as ", staged_column_name) order by question_number)) 
from 
  kubernetes-public.k8s_prod_readiness.survey_2021Q2_questions

This particular on is to use the output to create a new query with better column names, but I'll have others as well.
@ameukam
Copy link
Member

ameukam commented Sep 15, 2021

@deads2k Can you check if the BQ table survey_2021Q2_questions is present ? We created the dataset k8s_prod_readinesss without tables.

@deads2k
Copy link
Contributor Author

deads2k commented Sep 16, 2021

Yes, I created the table by importing a google sheet. See screenshot.

Screenshot from 2021-09-16 08-42-14

@spiffxp
Copy link
Member

spiffxp commented Sep 16, 2021

/priority important-soon
/sig architecture
/area access
/milestone v1.23
/kind bug

@k8s-ci-robot k8s-ci-robot added priority/important-soon Must be staffed and worked on either currently, or very soon, ideally in time for the next release. sig/architecture Categorizes an issue or PR as relevant to SIG Architecture. labels Sep 16, 2021
@k8s-ci-robot k8s-ci-robot added this to the v1.23 milestone Sep 16, 2021
@k8s-ci-robot k8s-ci-robot added area/access Define who has access to what via IAM bindings, role bindings, policy, etc. kind/bug Categorizes issue or PR as related to a bug. labels Sep 16, 2021
@spiffxp
Copy link
Member

spiffxp commented Sep 16, 2021

/assign
I'll take a look

@spiffxp spiffxp mentioned this issue Sep 16, 2021
Merged
@spiffxp
Copy link
Member

spiffxp commented Sep 16, 2021

Opened #2744

@deads2k
Copy link
Contributor Author

deads2k commented Sep 17, 2021

Works great. Thanks for the update.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@spiffxp spiffxp

Labels
area/access Define who has access to what via IAM bindings, role bindings, policy, etc. kind/bug Categorizes issue or PR as related to a bug. priority/important-soon Must be staffed and worked on either currently, or very soon, ideally in time for the next release. sig/architecture Categorizes an issue or PR as relevant to SIG Architecture.
Projects
None yet
Milestone
v1.23
Development

Successfully merging a pull request may close this issue.

tf/kubernetes-public: grant prr approvers bq job create spiffxp/k8s.io
4 participants
@spiffxp @ameukam @deads2k @k8s-ci-robot