Question

What is the behavior when columns or tables are deselected in the Fivetran UI? 

Answer

From the next sync onwards, no new data will sync for the deselected columns/tables.

The columns/tables will not be deleted from the destination. You will have to manually delete them if you want to remove them from the warehouse.