Merging 2 versions of an SCD table created from a managed ingestion pipeline
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Wednesday
We've been using the Salesforce Databricks connector to ingest data into Databricks with history tracking (SCD2) turned on. The licence to one of the add-on modules was accidentally revoked for our ingestion user and subsequently reinstated. This led to some columns generating the error CANNOT_WRITE_TO_INACTIVE_COLUMNS. I backed up the affected tables before doing a full refresh on the affected tables. What's the best way to merge the back up table and ingestion table?