topic Re: Is there a command in sql cell to ignore formatting for some lines like `# fmt: off` in Pytho... in Data Engineering https://community.databricks.com/t5/data-engineering/is-there-a-command-in-sql-cell-to-ignore-formatting-for-some/m-p/56664#M30616 <P>The sql formatter I'm using is whatever databricks notebooks in the workspace themselves are using (with Ctrl-Shift-F). Is that link related to databricks?</P> Mon, 08 Jan 2024 15:05:44 GMT jonathan-dufaul 2024-01-08T15:05:44Z Is there a command in sql cell to ignore formatting for some lines like `# fmt: off` in Python cells https://community.databricks.com/t5/data-engineering/is-there-a-command-in-sql-cell-to-ignore-formatting-for-some/m-p/56543#M30594 <P>In python cells I can add the comments `# fmt: off` before a block of code that I want black/autoformatter to ignore and `# fmt: on` afterwards. Is there anything similar I can put in sql cells to accomplish the same effect?</P><P>Some of the recommendations make the code far less legible.</P><P>Also is there any way to ignore single lines in the python cell?</P> Fri, 05 Jan 2024 22:10:42 GMT https://community.databricks.com/t5/data-engineering/is-there-a-command-in-sql-cell-to-ignore-formatting-for-some/m-p/56543#M30594 jonathan-dufaul 2024-01-05T22:10:42Z Re: Is there a command in sql cell to ignore formatting for some lines like `# fmt: off` in Pytho... https://community.databricks.com/t5/data-engineering/is-there-a-command-in-sql-cell-to-ignore-formatting-for-some/m-p/56664#M30616 <P>The sql formatter I'm using is whatever databricks notebooks in the workspace themselves are using (with Ctrl-Shift-F). Is that link related to databricks?</P> Mon, 08 Jan 2024 15:05:44 GMT https://community.databricks.com/t5/data-engineering/is-there-a-command-in-sql-cell-to-ignore-formatting-for-some/m-p/56664#M30616 jonathan-dufaul 2024-01-08T15:05:44Z Re: Is there a command in sql cell to ignore formatting for some lines like `# fmt: off` in Pytho... https://community.databricks.com/t5/data-engineering/is-there-a-command-in-sql-cell-to-ignore-formatting-for-some/m-p/58161#M31027 <DIV class=""><DIV class=""><DIV class=""><DIV class=""><DIV class=""><DIV class=""><DIV class=""><DIV class=""><P>I'll accept since it looks like the answer is a no for an ignore command in sql cells.</P><P>I found out that you can ignore single lines in python cells by putting `# fmt: skip` at the end. There has to be a space between the `#` and fmt or else you'll get a "AssertionError: INTERNAL ERROR: Black produced different code on the second pass of the formatter. Please report a bug on <A href="https://github.com/psf/black/issues" target="_blank" rel="nofollow noopener noreferrer">https://github.com/psf/black/issues</A>." error</P></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV> Mon, 22 Jan 2024 14:28:34 GMT https://community.databricks.com/t5/data-engineering/is-there-a-command-in-sql-cell-to-ignore-formatting-for-some/m-p/58161#M31027 jonathan-dufaul 2024-01-22T14:28:34Z