Implement BigQuery Rename Relation functionality

[azhard]

Describe the feature

Currently the BigQuery adapter function that allows you to rename a relation isn't implemented - this feature request simply aims to implement that functionality

Describe alternatives you've considered

Based on BigQuery documentation, there is no "out of the box" solution for this and instead, you must copy a table and then delete the original one so not much in the terms of alternative ways of handling this.

https://cloud.google.com/bigquery/docs/managing-tables#renaming_a_table

Additional context

It's worth noting that views cannot currently be renamed in BigQuery so support for that cannot be added.

https://cloud.google.com/bigquery/docs/managing-views#renaming_a_view

Who will this benefit?

BigQuery dbt users!

[drewbanin]

Thanks for opening this issue @azhard - we'll check out the PR!