It does tell me to try full refresh in the error. I haven't changed schema evolution, it is taking the default settings.

By full refresh do you mean to do Spark.Read instead of Spark.ReadStream? (Just to add I have tried doing Spark.Read but that creates a materialised view)