Big query alter table add column after a specific column in 2022

user6BPi1 0
Viewed 37

It's Not Working: ALTER TABLE table_name ADD COLUMN Marketing STRING AFTER COLUMN Detail STRING

OUTPUT: Syntax error: Expected end of input but got identifier "AFTER" at [4:82]

google-bigquery python
1 Answers

AFTER is not supported in creating DDL Statement as per this documentation. This statement works:

ALTER TABLE `<table_name>` ADD COLUMN Marketing STRING

Output:

enter image description here

You can just query the columns next to each other to achieve desired output.

Anjela B0
Related