If you:
- Currently don’t see a project in the Setup Upload menu:
- Or are getting error messages about access rights when trying to setup new upload definitions or edit existing upload definitions…
….then your email needs to be added into the IAM section of your GCP project:
The caveat is that you may not be able to do this yourself because this hugely depends on the settings of your GCP project – you may not even have access to the project yet unless you’ve setup the project yourself.
We recommend to talk to your IT guys who are usually managing access rights and ask them ideally for “BigQuery Admin” role for the email which your are using with Google Sheets.
And that’s all!
I have installed the Add-on and ready to buy but waiting to see a successful upload. I configured my first Upload Definition (my Proj ID was displayed) and I my email is in the IAM table in BQ. However, the uploader has been running for 30 min now with no sign of life on a sheet/table of about a 1000 rows. Any thoughts?