I am trying to read a view in snowflake using spark.read.format(“snowflake”).options(**options).option(“query”,”Set date=’03-02-2018′;Select * from View123″).load().
this is giving me SQL compilation error.
I understand that its because of the set date but I need it cause this View123 needs it to run.

please help!!!!

I tried running with multiple read formats but it didn’t work