How to handle schema changes in streaming Delta Tables?

- - Certifications
- - Learning Paths
- - Databricks Product Tours
- - Get Started Guides

- - Get Started Resources
- - Events
- - Support FAQs
- - Technical Blog
- - Community Articles
- - Announcements
- - DatabricksTV
- - Product Platform Updates

- - Private Groups
  - Princeton Life Sciences Databricks User Group
- - Skills@Scale

- - Databricks Community Innovators
- - Khoros Community Forums Support (Not for Databricks Product Questions)
- - Databricks Community Code of Conduct

Data Engineering

Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.

I'm using Structure Streaming when moving data from one Delta Table to another.

How to handle schema changes in those tables (e.g. adding new column)?

1 REPLY 1

Hello,

I think the only way of handling is to mention the schema within the job through a schema file. The other way is to restart the job to infer the new schema automatically.