Why was SQL formatting removed inside spark.sql functions? Now it looks like a plain string.

[EmilioGC]

Previously we were able to see SQL queries inside spark.sql() like this:

But now it just looks like a plain string:

 

I know it's not a big issue, but it's still annoying to have to code in SQL while having it all be blue, it makes debugging more cumbersome. Is there any way to change it back to the way it was?

[Mailendiran]

Did you find any solution for this?

While debugging, It is annoying actually.

[Hubert-Dudek · Accepted solution]

You need to go to "User settings." Then to "Editor settings" and activate the option "New notebook editor".

[Mailendiran]

Thanks . Plain blue has gone now.😀

[EmilioGC]

Awesome thanks a lot

[jose_gonzalez]

Hi @Emilio Garza​,

Just a friendly follow-up. Did any of the responses help you to resolve your question? if it did, please mark it as best. Otherwise, please let us know if you still need help.