Append Mode: Only new rows appended in the result table since the last trigger are written to external storage. This is applicable only for the queries where existing rows in the Result Table are not expected to change. https://docs.databricks.com/getting-started/spark/streaming.html