For the BigQuery source I imagine you are correct that the viewer role would be enough, can you try and confirm? The docs could be updated to reflect this. It might have just been a copy and paste from the Bigquery destination doc which definitely needs some of the editor permissions