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. [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 →
  2. [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 →
  3. [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 =';',
    STRING_DELIMITER = '0x22',
    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 →
  4. Replicated Table Support

    The feature is similar to that of redshift's Distribution style all. This will reduce data transfer between distributions/nodes and consequently improve performance.

    204 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

    19 comments  ·  SQL/Performance  ·  Flag idea as inappropriate…  ·  Admin →
  5. PolyBase: allow skipping header rows in delimited text files

    Setting reject rows in Polybase to ignore the header row is a hack. And if you have all string columns your header won't be rejected. Please add an IGNOREHEADERROWS = <numRows> option to Polybase

    175 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

    17 comments  ·  SQL/Polybase  ·  Flag idea as inappropriate…  ·  Admin →
  6. Add IDENTITY Types

    The fact IDENTITIES and SEQUENCE Types are missing makes it very difficult to generate surrogate keys. It seems the only pattern available is to combine ROW_NUMBER() with a select max from table, which is horribly clunky and won't work if parallel treads are loading into the table.

    160 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

    10 comments  ·  SQL/Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
  7. Row-Level Security

    It would be great to implement Row-Level Security on SQL Data Warehouse.
    That would be a great solution for scenarios where (for example) we have clients like PowerBI using data from SQL warehouse, and persons who have limited data access.

    159 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  ·  SQL/Security  ·  Flag idea as inappropriate…  ·  Admin →
  8. PolyBase: support for Azure Data Lake Store

    Polybase should add support for Azure Data Lake. I'm hopeful that will give us an option to do Polybase on top of files which are encrypted at rest.

    143 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

    10 comments  ·  SQL/Polybase  ·  Flag idea as inappropriate…  ·  Admin →
  9. 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 →
  10. 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 →
  11. 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 →
  12. PolyBase: allow retrieving rejected rows in an error file

    Let's say you define an external table with:

        REJECT_VALUE = 1000,
    
    REJECT_TYPE = value

    That means that it can reject and discard 1000 rows without failing the entire command.

    Please enhance Polybase to give us visibility into which rows were rejected and why. I would propose you can define an error output file where rejected rows get written. Either that or let us query some DMV to get a copy of the complete row as a string and the error reason.

    112 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

    15 comments  ·  SQL/Polybase  ·  Flag idea as inappropriate…  ·  Admin →
  13. SQL Data Warehouse endpoint in the Virtual Network

    Currently Azure DWH is only accessible using the host name of logical SQL Server and all traffic goes through public Internet.

    Would be great to have an endpoint with a reserved IP within the Virtual Network to ensure given logical SQL Server is seen as an internal resources within the corporate network.

    103 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/Security  ·  Flag idea as inappropriate…  ·  Admin →
  14. 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 →
  15. Use SELECT for setting variables (SELECT @MyVar = Col1, @MyVar1 = Col2 ...)

    Because we cannot do SELECT @MyVar = Col1, we are forced to utilize the same code to execute the exact same sql, to assign multiple variables.

    59 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 →
  16. 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 →
  17. 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 →
  18. [In preview] Import files via single COPY command from blob store.

    This feedback item is currently in preview here:

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

    It shouldn't require 5+ unintelligible queries just to import a file from blob store. Redshift lets me import files (including zipped files) from S3 with a single COPY command.

    44 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 →
  19. Support for the full length of T-SQL statements that are run in an Azure SQL Data Warehouse

    The customer I’m working with is asking if there’s a way to know the full length of T-SQL statements that are run in an Azure SQL Data Warehouse instance.
    They are using sys.dmpdwexec_requests, but it truncates the query text keeping 4000 bytes.

    34 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  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →

    We are excited to announce that we have implemented Query Store for Azure SQL Data Warehouse. Query Store enables storing the full query text and aggregated execution statistics for all queries for a period of 7 days. You can learn more about Query Store in our blog post:

    https://azure.microsoft.com/en-us/blog/automatic-performance-monitoring-in-azure-sql-data-warehouse-with-query-store/

    Matt Usher
    Principal Program Manager
    Azure SQL Data Warehouse team

  20. Authenticate from Azure AD

    Allow users to authenticate using Azure Active Directory in addition to SQL Server authentication.

    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

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

Feedback and Knowledge Base