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. [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
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    103 comments  ·  Integration  ·  Flag idea as inappropriate…  ·  Admin →
  2. 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
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    19 comments  ·  Performance  ·  Flag idea as inappropriate…  ·  Admin →
  3. 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
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    17 comments  ·  Polybase  ·  Flag idea as inappropriate…  ·  Admin →
  4. 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
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    10 comments  ·  Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
  5. 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
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Security  ·  Flag idea as inappropriate…  ·  Admin →
  6. 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
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    10 comments  ·  Polybase  ·  Flag idea as inappropriate…  ·  Admin →
  7. 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
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    6 comments  ·  Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
  8. 120 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    6 comments  ·  Security  ·  Flag idea as inappropriate…  ·  Admin →
  9. 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
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    14 comments  ·  Polybase  ·  Flag idea as inappropriate…  ·  Admin →
  10. 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
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Security  ·  Flag idea as inappropriate…  ·  Admin →
  11. 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
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    6 comments  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  12. 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
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  T-SQL  ·  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
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    completed  ·  6 comments  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  14. 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
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  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

  15. Authenticate from Azure AD

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

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

    We’ll send you updates on this idea

    4 comments  ·  Security  ·  Flag idea as inappropriate…  ·  Admin →
  16. 29 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 →
  17. 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
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Flag idea as inappropriate…  ·  Admin →
  18. PolyBase: support for encrypted Azure Blob Storage (Storage Service Encryption)

    There is a requirement to never leave unencrypted data anywhere. Inbound data files are encrypted but will have to be decrypted before Polybase can read them. In order to satisfy this requirement, Polybase will have to have ability to read encrypted files.

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

    We’ll send you updates on this idea

    6 comments  ·  Polybase  ·  Flag idea as inappropriate…  ·  Admin →

    Starting April 2016, Azure Storage Service Encryption (SSE) for Azure Blob Storage is in Public Preview. With this feature, Azure Storage automatically encrypts your data prior to persisting to blob storage and decrypts prior to retrieval, providing encryption at rest. We have tested this feature and PolyBase supports reading/writing data to encryption-enabled Azure Blob Storage. To learn more about Azure Storage Service Encryption, refer to https://azure.microsoft.com/en-us/documentation/articles/storage-service-encryption/.

    Thanks again for sharing your feedback with us. 6891055

  19. Enable Integrity and Privacy options for hadoop.rpc.protection setting

    Enable Integrity and Privacy options for hadoop.rpc.protection setting.
    Currently it only connects to Cloudera when set to Authentication, this doesn't provide sufficient security for storing/processing sensitive data.

    MS Work Items: 9519053 and 10001755.

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

    We’ll send you updates on this idea

    5 comments  ·  Polybase  ·  Flag idea as inappropriate…  ·  Admin →
  20. 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
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3
  • Don't see your idea?

Azure Synapse Analytics

Categories

Feedback and Knowledge Base