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. Allow folding/expanding of views and tables in the same schema in GUI

    It seems common to end up with many tables and views in a single Synapse database, partly due to no cross-database querying support. Browsing tables and views in the workspace soon becomes cumbersome.

    Please add functionality in the workspace GUI to fold and expand tables/views in the same schema! Imagine browsing views and tables in Synapse like you browse folders in e.g. Visual Studio Code!

    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/Management  ·  Flag idea as inappropriate…  ·  Admin →
  2. Provide insights about resource usage in Synapse Serverless

    Currently it's fully intransparent for users of Synapse Serverless how much resources are used to execute a query and when/why requests are queued because current resources are used-up and other queries have to be finished until the new query can be started. That leads to situations where very fast commands don't execute for a long time just because another command is eating up resources. How can we understand why a command is queued?

    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  ·  SQL/Performance  ·  Flag idea as inappropriate…  ·  Admin →
  3. Skew Check Query includes Row Count from Compute Node

    Attached query from MS Docs is used to check the skewness of the tables but I observe the row count from below query is double the actual count in table as it is taking record count from Compute Node. To check and fix the query to give actual records instead of duplication.

    Select schemaname,
    table
    name,
    indexname,
    distribution
    policyname,
    table
    rowcount,
    [Max
    distributionrowcount],
    [Mindistributionrowcount],
    [avg
    distributionrowcount],
    CASE WHEN tablerowcount = 0 then -1
    else abs([Maxdistributionrowcount] *1.0 - [Mindistributionrowcount]1.0) / [Max

    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/SQL Scripts  ·  Flag idea as inappropriate…  ·  Admin →
  4. Apply file skipping by automatic use filepath() function

    In order for queries commanded by BI tools to work effectively, file skipping is applied when the content of the query (e.g. where = '20200101') matches a partition item by file path

    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  ·  Flag idea as inappropriate…  ·  Admin →
  5. Serverless Synapse Create External Table from CSV

    On a Serverless Synapse workspace, when I go to linked tab, I can right click on a parquet file and I get an option to "create external table", when I follow this same steps for a CSV file I do not get the option to "create external table". Can we make this option available for CSV files too?

    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  ·  SQL/Polybase  ·  Flag idea as inappropriate…  ·  Admin →
  6. AAD MSI/SPN Authentication Using ODBC on Synapse

    Currently only SQL Password authentication is supported via ODBC on Synapse. We prefer AAD auth (SPN/preferably MSI) due to compliance and security reasons. Hence it would be great to have this feature.

    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  ·  SQL/Security  ·  Flag idea as inappropriate…  ·  Admin →
  7. need to delete pipelines, linked services, datasets automatically in synapse which are unused.

    Actually we published the pipeline into new workspace but there are some other pipelines, linked services, datasets which are unwanted so I deleted them manually but I want to automate them by creating a build a release so, it can automatically delete the unwanted ones.

    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/Pipelines  ·  Flag idea as inappropriate…  ·  Admin →
  8. Synapse: Hide list of database(s) when a user does not have access.

    The issue issue where objects (databases) are listed within the Synapse workspace, even if the user does not have access to it. When the user tries to navigate to the database, they get a red x, attached is an example:

    The request is for a DCL statement that : GRANT / REVOKE LIST on <<database_name>> to user/group.

    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/Other  ·  Flag idea as inappropriate…  ·  Admin →
  9. Cross Database query in Synapse

    Hi - Please enable cross database querying in Synapse workspace. We have two SQL Server Pools and trying to access the Table1 from Pool1 in Pool2 using SQL Script in Synapse Workspace and its saying "This feature is not supported in this version of SQL Server".

    thanks

    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/SQL Scripts  ·  Flag idea as inappropriate…  ·  Admin →
  10. Serverless Pool and External Table/ CETAS support for Azure Storage Tables and Queues

    serverless pools and copy into should be enhanced to support pulling data and writing to azure storage tables and queues.

    Azure tables are frequently used for applications to write log data using serverless to query aggregate and transform log data insitu would be extremely useful and cost effective way to analyse data

    Supporting storage and Queues for COPY Comand, CETAS and External Data Sources would be a great enhancement.

    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  ·  SQL/Loading  ·  Flag idea as inappropriate…  ·  Admin →
  11. TTL feature for IR in Azure Synapse Analysis

    TTL feature for IR in Azure Synapse Analysis so that the lag between DataFlow run is not there.

    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/Management  ·  Flag idea as inappropriate…  ·  Admin →
  12. GRANT IMPERSONATE ON USER on ServerLess Pool

    GRANT IMPRSONATION ON USER::User1 TO User2 is not working for the serverless pool in synapse although Microsoft’s documentation says it is applicable. overall Grant Database Principals doesn't work in Serverless pool.

    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  ·  Flag idea as inappropriate…  ·  Admin →
  13. Support manage connection policy

    Add the ability to change the connection policy, like Microsoft.sql
    I want to apply Redirect to accesses from outside Azure to optimize throughput.

    https://docs.microsoft.com/en-us/cli/azure/sql/server/conn-policy?view=azure-cli-latest

    9 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/Management  ·  Flag idea as inappropriate…  ·  Admin →
  14. Support ipywidgets in notebooks

    This will enable multiple useful packages to operate within Synapse.

    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 →
  15. 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).

    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 →
  16. LABEL clause should be extended to support character substitution

    the label clause should be extended to support character substitution similar to the functionality of the printf function in the C standard library.

    Here would be a an example: OPTION LABEL(N'This is step %d in sproc %s ', 5, N'number');

    Currently it is cumbersome to build dynamic label strings in non-Dynamic sql. Adding this capability would enhance query traceability by adding key contextual information with a simple and standard interface and reduce some of the need for custom logging frameworks.

    This would also align it with the current RAISEERROR capabilities and provide a more consistent feature surface area

    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  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  17. 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/Spark  ·  Flag idea as inappropriate…  ·  Admin →
  18. support custom resource group naming

    SQL Synapse deploy creates a managed resource group named: synapseworkspace-managedrg---***-xxxx-xxxx, it would be great if we can set our own resource group name in the ARM template, similarly to Kubernetes and Databrick. It will allow us to follow Resource group naming standards. If we have multiple synapse analytics in the subscription it will be easier for business users to look up cost/billing information if the resource groups can be named appropriately

    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  ·  Flag idea as inappropriate…  ·  Admin →
  19. Support setting Active Directory Admin using ARM Template

    Support setting Active Directory Admin using ARM Template similarly to the SQL Server ARM Template

    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  ·  Flag idea as inappropriate…  ·  Admin →
  20. SQL Data Tools for Synaspe Serverless

    https://cloudblogs.microsoft.com/sqlserver/2019/11/07/new-in-azure-synapse-analytics-cicd-for-sql-analytics-using-sql-server-data-tools/ describes how SQL Server Data Tools support for Synapse not mentioning that this is only for Dedicated Pools. We need similar support for Synapse Serverless as well otherwise CI/CD will be hard to handle.

    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  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5 22 23
  • Don't see your idea?

Feedback and Knowledge Base