How to auto-remove columns that no longer exists on data source?

How to auto-remove columns that no longer exists on data source?

Hi!

I have a table like this on BigQuery:

id | name | description | unit_price | quantity 

I imported it on Zoho and created a calculated column. Now I have this:

id | name | description | unit_price | quantity | total_price

Then, I rename some fields on BigQuery:

id | name | details | unit_value | quantity

When I refresh data on Zoho, my table changed to:

id | name | description | unit_price | quantity | total_price | details | unit_value

And now unit_price and description are empty and total_price is unknown.

So, I want to know:
1) There is a way to remove automatically those columns that is no longer on data source? Or do I need to remove manually each one of them?
2)  There are a location that indicates who column had been updated or not?


Thanks in advance,

Pedro