I have a Delta Live Table whose source is a Kafka stream. One of the columns is a Decimal and I need to change its precision.
What's the correct approach to changing the DLT's schema?
Just changing the column's precision in the DLT definition will result in an error running the pipeline - the old and new columns are incompatible, even if it's the same type but a different precision. And the overwriteSchema/mergeSchema options are not valid for a Kafka stream.
My current options are:
- Deleting the DLT and letting the pipeline rebuild it
- Changing the DLT's column through ALTER TABLE
