Transformations: Ability to Rename and Drop tables on Target
Currently HVR can create tables on a Target location and populate them. It can also modify the structure of the table.
However, it cannot rename the table or drop it.
If there's a need to do this, it has to be done directly at the Target database or using a different ETL tool.
-
HVR supports propagation of table drop operations with AdaptDDL OnDropTable (https://fivetran.com/docs/local-data-processing/action-reference/adaptddl#ondroptable).
Likewise HVR supports alter table rename per the DBMS specific operations in https://fivetran.com/docs/local-data-processing/action-reference/adaptddl#behaviorforspecificddlstatementsandcapturedbmss.
Do note that AdaptDDL is not supported on all platforms (https://fivetran.com/docs/local-data-processing/capabilities#capture).
Hope this helps.
Mark.
Please sign in to leave a comment.
Comments
1 comment