I have a table with over 200 column names which are created with a temporary name like - custColum1 -custColum200. 

I have a mapping table which contains a list of custColum1-custColumn200 to which name it has to be mapped with. For example

```
Table1(custColum1,custColum2) 
Mappingtable(tempColumnName,RealColumnName) 
data in mapping table be like 
(custColum1,Role_number)
(custColum2,Person_name)

```

I need to change table 1 to Table1(Role\_number,Person\_name). 
Note: I cannot create table1 with this name sincew I don't know which column would be mapped. 

Was thinking if We could do something like creating a dynamic query and execute as shown below 

```
SET @Sql = 'ALTER TABLE TABLE_NAME RENAME Column columnName'
           print  (@Sql)
           EXEC (@Sql)

```

Is there a way to do this in BigQuery? Any ideas will be great