Suppose we need to modify a Delta Table - column "A" from Decimal to Integer. We want to ensure a smooth transition without causing disruptions to both the writers and readers in our production environment, especially considering the large volume of data involved (billions of data rows).
For contributors (writers), we have the ability to pause the streaming ingestion, so currently we se no issue in that regard.
For consumers (readers), we would love to minimize interruptions as much as possible.
What would the best practice be ? (Databricks)