Is it possible to alter table and add a column after a specific column in Big query ? something like Alter table <abc> add column <mnc> after <column_name> . If not then are there any other ways to do and receive the same result ?
You can modify a table schema following the documentation, there are different ways to modify a schema by using SQL data definition language (DDL)