microsoft / azuredatastudio

Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
https://learn.microsoft.com/sql/azure-data-studio
MIT License
7.54k stars 898 forks source link

Using ipywidgets #6380

Open flexthink opened 5 years ago

flexthink commented 5 years ago

Is it possible to use ipywidgets inside Azure Data Studio? I was using an existing Python installation that already had widgets enabled, but when I tried running notebooks with widgets, instead of the widgets being rendered, I got output similar to this:

Text(value='foo')

This usually happens in regular Jupyter if this command has not been run

jupyter nbextension enable --py widgetsnbextension

Is this a bug or are nbextensions unsupported in Azure Data Studio?

flexthink commented 5 years ago

... or am I, perhaps, missing a step in the set-up?

chlafreniere commented 5 years ago

We're looking into adding ipywidgets support into Azure Data Studio, but don't have support as of yet unfortunately. It is on our list of experiences to support in the future.

We'd love to hear how you use ipywidgets to get an idea of how we can prioritize this work.

flexthink commented 5 years ago

I frequently use notebooks for ad hoc report generation where the widgets are used to specify, say, a date range. This is also useful for exploratory data analysis.

Also, I feel Azure Data Studio could replace JupyterLab and be a more natural fit for me at work given I'm working on the Microsoft stack, and I use many other MS development tools (e.g. Visual Studio, Visual Studio Code, SQL Server Management Studio). I'm moving away from the latter now that Azure Data Studio has more functionality.

Other use cases:

denimad commented 3 years ago

Would be very useful too for compatibility with more notebook widgets. For example, qgrid requires enabled the ipywidgets and nbextension. This widget is very useful to render DataFrames from the pandas library.

danielatsherpack commented 1 year ago

It's 2022 and this still seems to be an issue.

I'm attempting to find the right environment for a small team to collaborate on data science projects, and thought Data Studio would be a nice fit since it helps us manage the database. My use case is similar to those above -- experimentation and making interactive data visualizations.