BigQuery: Add destination_table to %%bigquery magic to allow materializing query results #9598
Description
Discussed with @tswast over email, suggestion is:
We should not reuse the destination_var parameter. Also bq:// is not really something I've seen used in any other official BigQuery docs / libraries, and I don't think it's necessary.
Instead, I recommend adding a --destination_table argument which sets QueryJobConfig.destination.