Table suspension when applying DDLs to Bigquery target
I am moving data from SQL Server to BigQuery. Everything works fine until there are some DDLs performed at the source. At this point the tables as part of the replicate jobs are getting suspended.
I understand that it is a stated limitation that BigQuery as a target does not support DDLs such as Drop/Rename column and data type change.
I am reaching out to see if there is any alternate approach that someone has implemented to work around this limitation instead of just reloading the table every time this happens to accommodate the change.
The only alternative I can think of is to manually update the target, do a simple "unsuspend" on the table, then manually fix the data on the target for the changes that occurred while the table was suspended. This may or may not take more time and effort than reloading...
