Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

Cannot create a table with dataform due to drive credentials error

I am using Dataform to create a table on a dataset that I have created on a Google Cloud project, but I get this error: "Access Denied: BigQuery BigQuery: Permission denied while getting Drive credentials."

Why? What should I do about this?

In a compiled version of a sqlx dataform file I try to create or replace a table and this causes the error.

CREATE OR REPLACE TABLE my_project_id.my_data_set.my_table

I'm not using a table that reads something from Google Drive but I am creating a new one. The service account associated with my dataform project has Dataset Owner access rights to my_data_set, and interestingly the dataform project is able to create views, but not tables. 

Also, the dataform workspace uses a table that reads a Google Spreadsheet, but I don't get any errors on that. 

0 1 914
1 REPLY 1