Azure Synapse Analytics

Do you have an idea or suggestion based on your experience with Azure Synapse Analytics? We would love to hear it!

Please take a few minutes to submit your idea or vote up an idea submitted by another Azure Synapse Analytics customer. All of the feedback you share in these forums will be monitored and reviewed by the Azure Synapse Analytics engineering team. By suggesting or voting for ideas here, you will also be one of the first to know when we begin work on your feature requests and when we release the feature.

Remember that this site is only for feature suggestions and ideas! If you have technical questions please try our documentation, MSDN forum, or StackOverflow. If you need support, please open a support ticket with us.


  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. 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…

    21 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  2. MERGE statement support

    Support the MERGE sql statement to support management of SCD1 / SCD2

    399 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    21 comments  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  3. Remove Scalar Function limitiations

    Currently we can not do the following:

    use Global variables within UDF, which makes us to send it from the front end as a value. eg; @@DateFirst
    reference tables within the UDF
    reference temp tables within a UDF

    15 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    10 comments  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  4. Feature request: cursors

    Will cusors (https://msdn.microsoft.com/en-us/library/ms180169.aspx) be available anytime in future in Azure SQL Data Warehouse?

    13 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  5. Inline and Table Valued Function support

    Currently Functions can only return a single variable, but we need to be able to return full tables so we can use them within the WHERE clause.

    62 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  6. Enable Debugging für SQL DW

    We are migrating SQL Scripts written for MS SQL Server 2008 R2 which contain a lot of dynamic SQL. At this moment one of those scripts fails pointing to row 1 column 1. There is no logic in that row. Inserting print 'Step x reached' shows me, that the script fails at a part where 100 lines of a dynamic SQL are stored in a variable of type NVARCHAR(4000). I believe 4000 chars is not enough to capture this dynamic SQL. Nonetheless I would like to be 100% sure before I start re-engineering this script. When I start the debugger…

    8 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you for your feedback folks. We are actively looking into this scenario specifically with VS SSDT Database Project support with SQL Data Warehouse. Please continue voting and monitoring this item for updates. Thank you for your patience.

1 3 Next →
  • Don't see your idea?

Azure Synapse Analytics

Categories

Feedback and Knowledge Base