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. Stored procedure support for On-Demand SQL

    Currently Synapse On-Demand SQL doesnt support stored procedures. In case the On-Demand logic is to be operationalized or used from Synapse Orchestrate\ADF, it will be helpful to have stored procedures instead of copying data between external tables or building views combining different files.

    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

    completed  ·  2 comments  ·  SQL/Integration  ·  Flag idea as inappropriate…  ·  Admin →
  2. Allow CosmosDB linked data to be queried from SQL on-demand

    It would be really awesome to be able to query CosmosDB linked data using SQL on-demand! (too bad this isn't aready possible at this moment with synapse-link in preview).

    Please add this feature.

    11 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

    completed  ·  0 comments  ·  SQL/Integration  ·  Flag idea as inappropriate…  ·  Admin →
  3. Use statement doesn't work in Synapse serverless

    This sequence of statements doesn't work, after the USE statement, the context is still on master database, anything we execute will be on master.

    Create Database NYTaxi2
    GO
    use NYTaxi2
    GO

    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 →
  4. CETAS failing on SQL On demand pool

    The following script is able to create an external table, but the select on the external table fails:

    REATE EXTERNAL TABLE weather2
    WITH (

        LOCATION='/weather2",  
    
    DATA_SOURCE = demoMalta,
    FILE_FORMAT = parquetformat

    )
    AS
    (SELECT
    top 100 *
    FROM

    OPENROWSET(
    
    BULK &#39;<a rel="nofollow noreferrer" href="https://azureopendatastorage.blob.core.windows.net/isdweatherdatacontainer/ISDWeather/year=*/month=*/*.parquet&#39;">https://azureopendatastorage.blob.core.windows.net/isdweatherdatacontainer/ISDWeather/year=*/month=*/*.parquet&#39;</a>,
    FORMAT=&#39;PARQUET&#39;
    ) AS [weather]

    )

    By changing slightly the location, everything works: LOCATION='/weather2/"

    This seems a bug. The table should not be created in the first place if the select over the table will fail. The creation managed to understand the location, but the select doesn't.

    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 →
  5. Cost Control for on Demand Mode

    On demand pool is very interesting, I have a lot of use cases in Production, But I need a cost control in place, having the option to limit how much size Query I can do by day.

    Currently, it is scary to use it in production and not knowing how much it will cost at the end of the Month

    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 →
  6. Allowing user to use local timezone is very necessary, it's not easy for users to change their programs to meets UTC timezone.

    Allowing user to use local timezone is very necessary, it's not easy for users to change their programs to meets UTC timezone.

    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

    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. Release Notes

    It would be very nice to have something like a page with Release Notes after every update to Azure DWH.

    Now you accidentally find out that something that did not work , works.

    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/Other  ·  Flag idea as inappropriate…  ·  Admin →
  8. 58 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/Loading  ·  Flag idea as inappropriate…  ·  Admin →
  9. sort a columnstore on CTAS/rebuild

    Columnstores can eliminate segments based on the min/max vaules of a column.

    For best performance, the data would need to be sorted by the users desired column, such as a date.

    See - http://www.nikoport.com/2014/04/16/clustered-columnstore-indexes-part-29-data-loading-for-better-segment-elimination/

    I'd love to see a syntax that looks something like the below (but without the need for creating a clustered index first)

    with
    (

    DISTRIBUTION = hash ( [store] ),
    
    clustered columnstore index (order by DateStamp)

    )

    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  ·  SQL/Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
  10. 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

    3 comments  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  11. Add Split_part function to SQL DW

    Just enable what's already in SQL (STRINGSPLIT) - it's the closest I've found to Redshift SPLITPART.

    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

    5 comments  ·  Flag idea as inappropriate…  ·  Admin →
  12. [In preview] Database project from Visual Studio to support Azure SQL Data Warehouse

    Database project from Visual Studio is useful to manage DDLs, schema compare between the project and database, etc. Please create a project template dedicated for DW or support DW development from Database Project.

    Download the Visual Studio 2019 preview here: https://docs.microsoft.com/azure/sql-data-warehouse/sql-data-warehouse-install-visual-studio

    951 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

    105 comments  ·  SQL/Integration  ·  Flag idea as inappropriate…  ·  Admin →
  13. Support 'AT TIME ZONE'

    To run global reporting, need to support 'AT TIME ZONE' as found in SQL Server 2016 - https://msdn.microsoft.com/en-us/library/mt612795.aspx

    45 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

    completed  ·  6 comments  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  14. ANSI joins support in UPDATE & DELETE statement

    SQL DW does not support to usual way of joins (ANSI) in UPDATE, DELETE statement. This makes difficult in case of table data modification. Though there is a workaround provided for CTAS this seems to be a lengthy process of data modification. Please have this feature available in SQL DW.

    136 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  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  15. Add support of JSON format

    Please add support of JSON data format like just happened for SQL Server 2016 and Azure SQL Database with JSONVALUE, JSONQUERY, etc.

    133 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

    6 comments  ·  SQL/Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
  16. 120 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

    6 comments  ·  SQL/Security  ·  Flag idea as inappropriate…  ·  Admin →
  17. support for TRY_CONVERT or TRY_CAST functions

    Azure SQL DW does not support tryconvert or trycast function in T-SQL. This is must needed function to validate the conversion of data types. We have custom date conversion function which uses try_convert to convert different date formats and getting on standard date format out. Please include this feature Azure SQL DW.

    78 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

    6 comments  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  18. Allow Unique Index on Columns that intersect the distribution column

    If SET tables aren't available, at least allow an UNIQUE INDEX to be placed on a table if the DISTRIBUTION column is found in the columns of the UNIQUE INDEX

    For example

    Table with locationid and productid with any number of fact columns. Partition the table by productid. All the data for any productid will be on one specific distribution. Allow that distribution to enforce uniqueness on locationid + productid.

    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

    4 comments  ·  SQL/Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
  19. [In preview] Polybase: allow field/row terminators within string fields

    This feedback item is currently in preview here:

    https://docs.microsoft.com/sql/t-sql/statements/copy-into-transact-sql?view=azure-sqldw-latest

    If a line end is present within a text field (qualified) importing data using Polybase will fail.

    Loading this line will work fine:
    1;2.1;"zzzz"

    Loading this will fail:
    1;2.1;"zz
    zz"

    Code:

    CREATE EXTERNAL FILE FORMAT textfileformat_raw
    WITH
    (

    FORMAT_TYPE = DELIMITEDTEXT,
    
    FORMAT_OPTIONS
    (
    FIELD_TERMINATOR =&#39;;&#39;,
    STRING_DELIMITER = &#39;0x22&#39;,
    USE_TYPE_DEFAULT = TRUE
    )

    );

    CREATE EXTERNAL TABLE dbo.testexternal
    (
    col1 INT,
    col2 DECIMAL(2,1),
    col3 NVARCHAR(5)
    )
    WITH
    (
    LOCATION = 'test
    failing.txt',
    DATASOURCE = azurestorage,
    FILEFORMAT = textfileformatraw

    );

    CREATE TABLE dbo.test
    WITH…

    236 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

    26 comments  ·  SQL/Loading  ·  Flag idea as inappropriate…  ·  Admin →
  20. [In preview] PolyBase: allow escaping string delimiters within string fields

    This feedback item is currently in preview here:

    https://docs.microsoft.com/sql/t-sql/statements/copy-into-transact-sql?view=azure-sqldw-latest

    If you want to quote the string columns, and if one of the quoted columns has a quote character in it, the proper way to encode this is to double the quote character. (Build a CSV file in Excel and you will see that's how it saves it. I would say Excel is the authority on CSV formats.)

    it appears it's impossible for Polybase to properly load that file. For example the following format is not interpreted right with STRING_DELIMITER = '"' since it divides the value 2.5" into two columns

    253 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

    29 comments  ·  SQL/Loading  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4
  • Don't see your idea?

Feedback and Knowledge Base