Panoply identifies any change (adding new data, making structural changes) to the source data as part of the collection process and automatically applies the updates to the destination schema.
Here are a few examples of how Panoply adapts in case of changes in the source data:
- If a column was added to your source data, Panoply recognizes it and adds it to the destination table.
- If the data type of a particular field was changed, Panoply recognizes it and applies the changes to the same field in the destination table.
- If a column was removed from the source data, Panoply does not remove it from the destination table but stops populating it with data. If needed, use the `ALTER TABLE table_name DROP COLUMN column_name` statement to remove the redundant column from the destination table.