unable to create schedule queries in bigquery

Question

I am trying to restrict a bigquery so that users can only access a specific datasets, i did so without any issues, but why user is not able to create scheduled queries? it is saying to enable api and only project owner can able to schedule queries , is there anyway to add permissions to create a custom role so that users can query,create and schedule queries ?

//dinesh

Answer 1

Ensure that the person creating the transfer has the following required permissions in BigQuery:

• bigquery.transfers.update permissions to create the transfer
• bigquery.datasets.update permissions on the target dataset

The bigquery.admin predefined Cloud IAM role includes bigquery.transfers.update and bigquery.datasets.update permissions. You should check the official documentation and the Cloud IAM roles in BigQuery to see the Predefined roles and permissions.