It’s also important to realize what happens when different users with different BigQuery rights oversave scheduler within a spreadsheet.
Let’s have these 2 users….:
- Joe has “BigQuery Data Viewer” rights to the project the spreadsheet is querying.
- Paul does not have sufficient BigQuery rights to the project.
The 2 users are committing this series of steps:
- Paul saves the scheduler to run hourly,
- Since the Paul does not have sufficient BQ rights, the scheduled queries will fail every single hour.
- Joe comes a few hour later and just resaves the scheduler. From this moment, the scheduled queries will execute OK because Joe has sufficient BQ rights to run the queries. Downloader will be simply using Joe’s credentials to run scheduled queries from that moment on.
The learning here is: The last user saving the schedule always “wins” and that’s the only schedule which will be running from the moment on. The credentials of the last saving user are used to run all the queries within your spreadsheet.