topic Re: Why was SQL formatting removed inside spark.sql functions? Now it looks like a plain string. in Data Engineering

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

EmilioGC — Thu, 02 Feb 2023 05:56:52 GMT

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?

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

Mailendiran — Tue, 14 Feb 2023 13:58:30 GMT

Did you find any solution for this?

While debugging, It is annoying actually.

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

Hubert-Dudek — Wed, 15 Feb 2023 10:44:16 GMT

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

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

Mailendiran — Wed, 15 Feb 2023 11:02:39 GMT

Thanks . Plain blue has gone now.😀

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

EmilioGC — Wed, 15 Feb 2023 15:33:16 GMT

Awesome thanks a lot

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

jose_gonzalez — Fri, 24 Feb 2023 23:52:00 GMT

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.