Update: Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year. We will leverage 1st party solutions for customer feedback. Learn more here.

Azure Synapse Analytics

We would love to hear your ideas for new features for Azure Synapse Analytics. Below, enter a new idea or upvote an existing one. The Synapse engineering team pays attention to all requests.

If instead you need a technical question answered or help, try the these options: DocumentationMSDN forum, and StackOverflow. If you need support, please open a support ticket.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. support for R notebook

    Would love to have support for the language R in the notebook experience of Synapse Studio.

    75 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    7 comments  ·  Workspace/Notebooks  ·  Flag idea as inappropriate…  ·  Admin →
  2. 19 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Workspace/Notebooks  ·  Flag idea as inappropriate…  ·  Admin →
  3. synapsesql(formerly sqlanalytics) supports append and overwrite write modes

    synapsesql(formerly sqlanalytics) write API needs supporting savemode as append , overwirte (drop and create )to work even if exist dedicated SQL Pool tables.
    This feature is a must for ETL workloads

    10 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Workspace/Notebooks  ·  Flag idea as inappropriate…  ·  Admin →
  4. Synapse Git integration support ipynb notebook file format

    Synapse had git integration, but when we need to save / commit our work of notebook, we can only get JSON definition file of notebook in git repo.
    Currently If we need to make ipynb source code, we can only use "Export" btn to generate ipynb file, but its not integrated with git repo, so it still lose source control ability of that ipynb file, also its hard to code review using JSON format file.
    It would be very helpful if we can also keep ipynb format when integrating with Git Repo

    7 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Workspace/Notebooks  ·  Flag idea as inappropriate…  ·  Admin →
  5. Autosave Synapse Notebooks

    For users coming from a DataBricks or Jupyter environment to Synapse, one of the features that Synapse does not have is auto-saving a notebook. So if I forget to click the "Publish" button, and happen to close my browser or my browser crashes/closes unexpectedly, I lose all of my work. Where with ADB or AML Notebooks, I don't have to worry about that extra step.

    6 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Workspace/Notebooks  ·  Flag idea as inappropriate…  ·  Admin →
  6. Support for running unpublished (git/ado/sandbox) notebooks in %%run magics/mssparkutils

    Right now, %%run magics only work in Synapse live mode. However, we want to keep notebooks cleanly split up both in development and production.

    I think it makes sense because there is a pool startup overhead to using multiple notebooks sequentially in an Integration Pipeline.

    4 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Workspace/Notebooks  ·  Flag idea as inappropriate…  ·  Admin →
  7. Support ipywidgets in notebooks

    This will enable multiple useful packages to operate within Synapse.

    4 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Workspace/Notebooks  ·  Flag idea as inappropriate…  ·  Admin →
  8. Show Dataframe Schema in the Cell Result

    In Databricks notebooks, when you execute a cell with code to create a Dataframe, you get to see the schema of the Dataframe in the cell’s output. Although we can always run printSchema() on the Dataframe, this feature comes in pretty handy (one less thing to worry about).

    4 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Workspace/Notebooks  ·  Flag idea as inappropriate…  ·  Admin →
  9. Add ability to import Databricks Notebook

    As a Data Engineer, I want to import my existing Databricks notebooks directly from a Databricks workspace and have that have it converted to run on Azure Synapse.

    When the notebook imports, references to incompatible features should either be
    - commented out, indicated as incompatible features, and have links supplied to documentation for the synapse equivalent

    OR BETTER YET

    • provided with a wizard to handle the setup of the workaround

    For example:

    Notebooks reference existing schemas and tables, so enable automated import of schemas and external table definitions from a running databricks’ hive meta store.

    External tables reference storage so…

    4 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Workspace/Notebooks  ·  Flag idea as inappropriate…  ·  Admin →
  10. 4 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Workspace/Notebooks  ·  Flag idea as inappropriate…  ·  Admin →
  11. Enable or disable a cell in a notebook

    We need to enable or disable a block of code in a cell in notebook. The feature is not there..

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Workspace/Notebooks  ·  Flag idea as inappropriate…  ·  Admin →
  12. Use browser notifications in Synapse studio windows to signal end of execution and tasks (notify users)

    For lengthy operations (configurable?) add support for native browser notifications, so instead of users wait and/or constantly peeking regarding a running cell/task, they can switch to other thing and be notified when that ends (success or error),etc

    Could be extended to any lengthy operation, constant peeking rather unproductive.
    similar extension for native jupyter (triggered on kernel becomes idle after configurable time)
    https://jupyter-contrib-nbextensions.readthedocs.io/en/latest/nbextensions/notify/readme.html

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Workspace/Notebooks  ·  Flag idea as inappropriate…  ·  Admin →
  13. editing a code within a cell in one line is hard

    If you write a one line long code in a cell in the notebook, it is really hard to highlight part of it in order to copy it. or it is very difficult to edit the one liner coder in the cell (the cell jumps from one end to another when you try to highlight it or scroll to the right or left of the cell).. Please fix this buggy/frustrating edit in a cell.. (perhaps you can add a feature to break down a one line code into multiple lines automatically so it is easier to see it and edit…

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Workspace/Notebooks  ·  Flag idea as inappropriate…  ·  Admin →
  14. separate user output from system logs in drivet logs

    Currently, user stdout and stderr are pushed to driver stderr. Given hundreds of K lines with system warnings, errors and status updates, it's very difficult to find cell output in the logs. How about separating?

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Workspace/Notebooks  ·  Flag idea as inappropriate…  ·  Admin →
  15. Allow Notebooks to connect to Integration Runtimes

    I would like to query on prem sources though a JDBC connection in a python notebook. I can do this through my Copy Data task because it points to the runtime that gives me access to my on prem source. My notebook on the other hand thinks that my database is always available through the open internet and there is no way to point it to the runtime.

    I'm not sure if this is technically possible...

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Workspace/Notebooks  ·  Flag idea as inappropriate…  ·  Admin →
  16. Allow Notebooks to connect to Integration Runtimes

    I would like to query on prem sources though a JDBC connection in a python notebook. I can do this through my Copy Data task because it points to the runtime that gives me access to my on prem source. My notebook on the other hand thinks that my database is always available through the open internet and there is no way to point it to the runtime.

    I'm not sure if this is technically possible...

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Workspace/Notebooks  ·  Flag idea as inappropriate…  ·  Admin →
  17. Scrolling in Synapse Spark notebooks

    When doing notebook cells the newest cell is usually at the bottom of the page. In other editors (like Databricks notebooks) it is possible to "overscroll" the final cell a bit, meaning you can push it further up the page. However, at least when using Edge, the Synapse Notebook does not scroll further, leaving the final cell always at the very bottom of the page. This is quite annoying when typing new content. I can of course make the browser window smaller, but it isnt very convenient either. It would help a lot if the bottom cell could just be…

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Workspace/Notebooks  ·  Flag idea as inappropriate…  ·  Admin →
  18. Diagnose long running notebook cell

    Often a notebook cell runs for a long time and does not return. Is it due to a lot of CPU crunching? waiting on I/O? Something else?

    Currently there is no way to tell. It would be nice to be able to stop the cell and get a stacktrace, or to have some indication if it's waiting on I/O, and/or otherwise get information useful for diagnosing long running cells.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Workspace/Notebooks  ·  Flag idea as inappropriate…  ·  Admin →
  19. Microsoft SQL notebook magics

    Hopefully this doesn't sound weird:

    Like: %%tsql, with the ability to run in a notebook and be called via pipeline.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Workspace/Notebooks  ·  Flag idea as inappropriate…  ·  Admin →
  20. editing a code within a cell in one line is hard

    If you write a one line long code in a cell in the notebook, it is really hard to highlight part of it in order to copy it. or it is very difficult to edit the one liner coder in the cell (the cell jumps from one end to another when you try to highlight it or scroll to the right or left of the cell).. Please fix this buggy/frustrating edit in a cell.. (perhaps you can add a feature to break down a one line code into multiple lines automatically so it is easier to see it and edit…

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Workspace/Notebooks  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1
  • Don't see your idea?

Feedback and Knowledge Base