This is our use case:

We need to replicate a source bigquery dataset (instance) to our bigquery dataset (instance), but on the source, we just have read permission, because we got depend on some team that we do not control or can't request on permission, no higher permission than read only. But on the destination, we have full control on that. Now, your bigquery connector does require more permission than the read only permission, can you make the improvement to the bigquery connector, instead of create any temporary table on the source to handle the data. You can do that on the end side, I'm mean on the destination side.

This will help us alot.

Thanks