Hi @yvishal519 did you get to know how to do a full load because "spark.readStream" do incremental loads. If I do "spark.read" it creates a materialised view.

What I want is:  do a full load each time(no need of scd types) and it should be a streaming table and not a materialised view.