How to handle schema changes in streaming Delta Tables?

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

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

- - Regional and Interest Groups
- - Private Groups

- - Databricks Community Champions
- - 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.