Share via

Azure Data Studio - Hide specific output components in notebooks.

B_Gage 5 Reputation points
2023-08-30T22:23:43.79+00:00

I am trying to learn Azure Data Studio to see if I can expand my knowledge beyond SSMS. I am finding it to not be very intuitive or user friendly. It must be more useful for users approaching from different development platforms, languages, environments, ect. . I am approaching it from a Visual Studio and SSMS perspective (Not Visual Studio Code, I am trying to learn that as well).

Basically I am trying to create a notebook that executes sever SQL queries against a SQL Server database.
(It would be nice to have global parameters for SQL, but apparently we haven't gotten there yet.) My main question is how do you get rid of that big block of blank code between the query and results? It is a horrendous waste of space.

User's image

Looking at the markup using the developer tools, they have the <output-component> tag. It would seem somewhere in the notebook you can suppress these or even customize them. I really don't want them to take such a big chunk of space.

(Now if I can suppress the filter dropdown for each column that would save me a bunch more space as well. But that can be for another question.)

Azure Data Studio
Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
100 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Oury Ba-MSFT 16,886 Reputation points Microsoft Employee
    2023-09-01T15:45:05.26+00:00

    B_Gage Thank you for posting your question.

    Basically I am trying to create a notebook that executes sever SQL queries against a SQL Server database.
    (It would be nice to have global parameters for SQL.

    That feature is not supported yet by ADS.

    how do you get rid of that big block of blank code between the query and results.?

    This is a normal behavior in ADS platform.

    Please use the link provided by @Erin Stellato to log a request.

    Hope that helps.

    Regards,

    Oury

    0 comments
  2. Erin Stellato 486 Reputation points Microsoft Employee
    2023-09-01T18:13:41.5733333+00:00

    Hi @B_Gage thanks for your question. We do not currently have a setting available that allows you to change the amount of white space. Please enter a request item in the ADS GitHub repo (https://github.com/microsoft/azuredatastudio/issues). In addition, feel free to ask ADS-specific questions in the discussions section (https://github.com/microsoft/azuredatastudio/discussions).

    Thanks,

    Erin

    0 comments