topic Re: SQL Notebook Tab Spacing in Data Engineering

SQL Notebook Tab Spacing

KFries — Tue, 06 Aug 2024 21:14:11 GMT

My SQL notebooks in databricks suffer from having at least several different counts of spaces between tab marks. It makes it very difficult to maintain pretty code spacing. What sets the tab spacing in SQL language notebooks, and how is it set/adjusted? Also, I co-edit the notebooks using git/github and intelliJ (which could be a source of the problem), but I want the indenting to be correct for my tastes as rendered in the databricks notebook because that's where I run it with data. I am constantly adjusting spacing using the ctrl-squarebracket shortcuts.

Re: SQL Notebook Tab Spacing

Retired_mod — Thu, 08 Aug 2024 15:14:45 GMT

Hi @KFries, It sounds like you're dealing with a common issue with tab spacing in Databricks SQL notebooks. Databricks uses 2 spaces per tab by default, and while you can't change this setting globally, you can manually format your notebook via the "Edit > Format Notebook" option. If you're also using IntelliJ, ensure your tab and indentation settings there match your preferences for Databricks. For consistent formatting across tools, set up your `.editorconfig` file to enforce 2-space indentation in SQL files and use GitHub integration to maintain uniformity. Always format your code before committing to GitHub to keep things clean and consistent.

If you have any more specific issues or need further assistance, feel free to ask!

Re: SQL Notebook Tab Spacing

louisv-bambaw — Tue, 05 Nov 2024 16:09:36 GMT

I’m experiencing the same issue with SQL cell indentation in Databricks notebooks. While editing, I’ve noticed that the indentation level can vary from one cell to another - sometimes it’s two spaces, other times it’s four. This inconsistency makes it challenging to maintain a uniform look across SQL cells.

It would be helpful if there were a dedicated parameter for SQL cell indentation, similar to the existing “Indentation for Python cells in new notebooks (in spaces)” option for Python cells.