Do I need Notebook in ADS?

Susja 716 Reputation points
2023-08-03T18:56:41.56+00:00

Hello,

I am quite new to ADS. It looks attractive to me and I'm starting to understand it and see if it'll fit my need.

Note: my daily work include run SQL queries, create/modify existing ones, some database maintenance, writing / modifying Python script, run some 'unix-like' commands and etc only on Windows OS's. In other words .. not heavy on any component, kind of light weighted .. Hence ... I was looking for some kind of IDE which would serve my needs.

It looks that ADS would work for me and I started to read documentation. When I get to Notebooks .. it looks also attractive to me ... but I still can't find any advantage of using Jupiter Notebook in ADS in my case. E.g. if I need some SQL query .. I would simply use it directly from SQL option of ADS, if I need something in Python ... I could open Terminal and run from there ..

In other words: could you please 'convince' me that Notebook feature will bring me some good 'stuff' based on my routine ?

Thanks

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.
106 questions
Accepted answer
  1. Erin Stellato 531 Reputation points Microsoft Employee
    2023-08-04T01:58:48.7633333+00:00

    Hi @Susja - I'm not in the habit of trying to convince anyone to do anything, but Notebooks are useful for folks who like to create "runbooks" from their scripts. For example, perhaps there is a set of T-SQL commands that need to run in a specific order, and should have certain output, and a Notebook allows you to save the output (not an option for a T-SQL script) so that it can be viewed later. Folks in the data science space who run R and Python also find them useful (info here: https://video2.skills-academy.com/sql/machine-learning/install/sql-machine-learning-azure-data-studio).

    The question is really, "What problem are you trying to solve?" Based on what you've described, you do not HAVE to use notebooks. But if you find that you like the formatting options, saving output, and don't want to switch between the query editor and terminal, they might be great for you.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest