microsoft / microsoft/vscode-mssql

[Bug]: Use multiple kernels not working

Open
#22,575 0 comments 0 reactions 1 assignee Claimed by @yoleichen View on GitHub
Area - SQL Notebook Bug User-filed
Dominant language
TypeScript
Stars
1.9k
Forks
610
Avg merge
2d 3h
Merged PRs (30d)
97

Description

### Description

As per documentation "Use multiple kernels
The MSSQL extension provides the SQL kernel out of the box. You can extend your notebooks with more language kernels by installing the [Jupyter extension](https://marketplace.visualstudio.com/items?itemName=ms-toolsai.jupyter), which bundles support for Python and other kernels. You can combine SQL data queries with Python data processing and visualization cells in the same notebook."

anyway when i open a new Jupyter Notebook i can use only 1 kernel. I try to modify the language of the cell but when MSSQL kernel is selected I can see only SQL or Markdown.
Viceversa in the notebook is set a python then i can pick SQL as language of the cell, I'm able to select also a database in the cell but if i run a sql query I receive from the python interpreter a syntax error.
Is this a bug or is there any more detailed documentation that explain how to combine SQL and python inside the same notebook?

### Steps to Reproduce

Open a new Jupyter Notebook
select MSSQL as kernel
create a cell with SQL code
create a cell with python code
Open a new Jupyter Notebook
select python as kernel
create a cell with SQL code
create a cell with python code

### Affected Area

- [ ] Connection dialog (SQL Server | Azure browse/Fabric browse)
- [ ] Query editor
- [ ] Query results panel
- [ ] Object Explorer
- [ ] GitHub Copilot integration
- [ ] Preview/Edit data
- [ ] Table Designer
- [ ] Schema Designer
- [ ] Schema Compare
- [ ] Local SQL Server Container provisioning
- [ ] SQL database in Fabric provisioning
- [ ] DACPAC/BACPAC export/import
- [ ] SQL Database projects
- [ ] Query Plan Visualizer
- [x] Other (please describe below)

### If you selected "Other", please describe the affected area

_No response_

### Environment Information

VS Code version: 1.131.0
MSSQL version : 1.44.1
Windows 11
Azure SQL Server/SQL Server

### Confirmation

- [x] I have searched existing issues and couldn't find a match
- [ ] I want to work on this issue

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.