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 EXECUTE AS for stored procedures

    As part of the ELT procedure the user staging data should be able to call a transform procedure to ingest the data without having read/write permissions to the production tables.

    31 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

    4 comments  ·  SQL/Security  ·  Flag idea as inappropriate…  ·  Admin →
  2. Connectivity to code repositories (similar to Data Factory)

    It looks like the Azure Synapse suite is going to supplant Azure Data Factory. For completeness, Azure Synapse will have to be able to integrate with code repositories (Github / Azure DevOps Repos) and be able to align with the CI/CD process that ADF currently recommends (https://docs.microsoft.com/en-us/azure/data-factory/continuous-integration-deployment)

    30 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

    2 comments  ·  Workspace/Management  ·  Flag idea as inappropriate…  ·  Admin →
  3. Need alert on number of queued queries and number of concurrency slots available in portal

    The charts in the SQL DW blade in the portal and the ability to add alerts are very helpful. Please add additional metrics. The two metrics that I think would be helpful are:

    Number of Queued Queries (meaning after you've exhausted your 32 concurrent queries or your concurrency slots or the queued query needs more concurrency slots than are available, queries get queued)

    Number of Concurrency Slots Available (the sum of concurrency slots used by currently running queries... would help surface whether you need to scale to more DWUs)

    30 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/Management  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you for voting for this folks! This is on our radar. We have plans to improve workload management for Azure SQL Data Warehouse which includes monitoring capabilities within the Azure portal. We’d love to hear your feedback so please comment on your scenario below.

  4. Allow DBCC results (e.g. DBCC PDW_SHOWSPACEUSED..) to be copied into yet another table for programmatic interaction with those results?

    IF OBJECTID('tempdb..#showspace_used') IS NOT NULL

    DROP TABLE #show_space_used
    
    

    CREATE TABLE #show_space_used
    (
    [ROWS] INT NULL
    , [RESERVED_SPACE] INT NULL
    , [DATA_SPACE] INT NULL
    , [INDEX_SPACE] INT NULL
    , [UNUSED_SPACE] INT NULL
    , [PDW_NODE_ID] INT NULL
    , [DISTRIBUTION_ID] INT NULL
    )
    WITH
    (
    DISTRIBUTION = HASH([ROWS])
    , HEAP
    )

    DECLARE @DynamicSQL nvarchar(4000)
    SET @Dynamic
    SQL = (SELECT CONVERT(NVARCHAR(100),'DBCC PDW_SHOWSPACEUSED("dbo.TableName");'))

    INSERT INTO #showspaceused ([ROWS], [RESERVEDSPACE], [DATASPACE], [INDEXSPACE], [UNUSEDSPACE], [PDWNODEID], [DISTRIBUTIONID])
    EXEC sp
    executesql @Dynamic_SQL

    Msg 103010, Level 16, State 1, Line 326
    Parse error at line: 25, column: 1: Incorrect…

    29 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 →
  5. support for fixed width flat files in Polybase

    Polybase currently only supports delimited flat files. It should support fixed width flat files.

    29 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  ·  SQL/Loading  ·  Flag idea as inappropriate…  ·  Admin →
  6. Polybase support for other cloud data sources

    we currently has Polybase to Azure Blob Store.

    we need Polybase to the following data stores:

    HDInsight with push down compute?
    SQL Azure with push down compute?
    DocumentDB with push down compute?
    Azure Data Lake Store with push down to Azure Data Lake Analytics?

    28 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/Polybase  ·  Flag idea as inappropriate…  ·  Admin →
  7. JDBC connection to Spark Pool

    Please support JDBC connection to Synapse Spark Pool.

    26 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/Spark  ·  Flag idea as inappropriate…  ·  Admin →
  8. Prevent DUPLICATE values. Allow Enforce constraints

    Please allow to ENFORCE UNIQUE AND PRIMARY KEYS in order to PREVENT DUPLICATE values

    25 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

    9 comments  ·  SQL/Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
  9. column default

    Support column default with expression. (E.g. Getdate())

    25 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

    under review  ·  2 comments  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  10. Support "RDBMS" TYPE for Create External Data Source

    Azure Synapse Analytics currently does not support creating external data sources to RDBMS databases such as Azure SQL, SQL Server, Orcale, etc.). However, this functionality is available in MS SQL Server 2019.

    24 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  ·  SQL/Polybase  ·  Flag idea as inappropriate…  ·  Admin →
  11. Add "DROP Partition" command

    Having drop Partition command that automatically merges the partition boundaries and removes the partition would help a lot.

    24 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 →
  12. Predicate pushdown for ADLS sources

    As Azure SQL DW now also supports ADLS, it would be great if we could also leverage the distributed processing capabilities of ADLS to push computation down to ADLS in a similar way as it works for HDFS/Hadoop already

    24 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

    2 comments  ·  SQL/Polybase  ·  Flag idea as inappropriate…  ·  Admin →
  13. support for R notebook

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

    23 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

    3 comments  ·  Workspace/Notebooks  ·  Flag idea as inappropriate…  ·  Admin →
  14. Re-instate geo-backup opt-out option for Gen2 DWs

    We have several TBs of data in multiple DWs. The critical data is static. The data footprint of the DW grows and shrinks as analytics are peformed on the static data. Once analytics complete, results are exported out of the DW and no longer need to be retained in the DW. Should something happen the DW, all we require is the ability to restore back to the original static data image (any interrupted analytics can be resubmitted). Regularly scheduled geo-backups, snapshots, and restore points provide no benefit to us other than bloating our data storage costs in Azure.

    According to…

    23 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

    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  15. OPENROWSET for dedicated pools

    Please add the OPENROWSET functionality dedicated pools.
    Advantages:
    1. More (and faster) parser options over External File Format such as row delimiter
    2. Can auto-infer schema
    3. More convenient to define the file format directly
    4. syntactical harmony between serverless and dedicated.

    22 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

    under review  ·  0 comments  ·  SQL/Polybase  ·  Flag idea as inappropriate…  ·  Admin →
  16. Support of StorageTable as DataSource

    Please add support of Azure TableStorage as PolyBase DataSource.
    To be honest I can't believe its not already available. :O

    22 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/Polybase  ·  Flag idea as inappropriate…  ·  Admin →
  17. SSDT: Row-level security

    SSDT support for Row-level security

    20 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

    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  18. Allow for Local Timezone to be set for SQL Azure DB's

    Allow for Local Time Zones to be set on SQL Azure DB's

    20 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  ·  SQL/Other  ·  Flag idea as inappropriate…  ·  Admin →
  19. Increase Concurrency limit as a tweakable system parameter

    Increase the concurrency limit from 32 to unlimited and keep it tweakable , so the customers can vary it according to their needs

    20 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  ·  SQL/Management  ·  Flag idea as inappropriate…  ·  Admin →
  20. Enable CDM support for Azure Synapse Analytics SQL on-demand

    The "Common Data Model" (CDM) format is becoming increasingly popular. Therefore it would be important that this connector not only exists in the ADF, but that it is also possible to read and write (via CETAS) in CDM directly from SQL on-demand.
    READ:
    SELECT * FROM

    OPENROWSET(
    
    BULK STORAGE ACCOUNT,
    FORMAT = CDM
    ) AS [r];

    WRITE:

    CREATE EXTERNAL TABLE cdm.cdm_table

    WITH (
    
    LOCATION = path_to_folder,
    DATA_SOURCE = external_data_source_name
    FILE_FORMAT = CDM

    ) AS SELECT * FROM source

    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

    under review  ·  1 comment  ·  SQL/Integration  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base