Multiple BigQuery Projects & Integration Options

I wanted to help and information on how to target multiple projects while using BQ as destination. I have requirement to send the data specific to project locations on BQ. What are the options including pushing the data to one project and then streaming it to the required project from there like pub-sub.

Please provide insights on how this can be achieved in automated process.