Question
What happens to the table in destination when it is renamed in the source?
Environment
Databases
Answer
Re-named objects will be treated as a new table and a deleted table.
For example, if you rename Table A to Table B, Fivetran will create a new Table B in the warehouse and sync any data into that table. Table A will no longer be synced to.