SQL Data Warehouse

Do you have an idea or suggestion based on your experience with SQL Data Warehouse? We would love to hear it! Please take a few minutes to submit your idea or vote up an idea submitted by another SQL Data Warehouse customer. All of the feedback you share in these forums will be monitored and reviewed by the SQL Data Warehouse 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. Cross Database Querying

    Enable elastic query for SQL DW - this would allow cross database query in SQL DataWarehouse.

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

    We’ll send you updates on this idea

    10 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  2. Add support for synonyms

    CTAS to a new table is often a pattern that's used in DW for data processing workloads. Instead of RENAME OBJECT operations from old tables to the new ones using CTAS, it would be great if we can add synonym support to DW, so that switching to the new table is an atomic operation, and is reliable.

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

    We’ll send you updates on this idea

    under review  ·  2 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  3. Enable Intellisense With SSMS

    Intellisense is a very handy feature when using SSMS to write queries against Sql Server databases. It increases development time by reducing typographical errors.

    It would be nice to have with Sql Data Warehouse.

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

    We’ll send you updates on this idea

    3 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you for all the feedback folks. Unfortunately full intellisense support for SSMS is taking longer than we’d like. We will reach back out when it is on the roadmap and can share when we have an update.

  4. Alow multiple SQL DataWarehouse instances to access the same data (.mdf files)

    This would allow an enterprise to have a Production Data Warehouse with SLAs in place while allowing a data scientist/Business user/Subject matter expert to do analytic and discovery work without impacting SLAs and without moving data (which usually is pretty large).
    At the same time it would allow for metered consumption and chargeback towards the subtenants that are conducting analytic discovery work.
    The functionality would be similar to what can already be done today with HDInsight and Azure Blob. Data in Azure blob can be independently accessed by multiple HDInsight clusters.

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

    We’ll send you updates on this idea

    3 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  5. <Offers>The things that it is possible by the Azure SQL Database, but not in Azure SQL Data Warehouse

    All of the following can be done with SQL Database (PssS) but not with SQL datawarehouse.

    1.When trying to import a file with BCP command after adding table column of SQL Data Warehouse side, An error occurs if the number of columns in the file to be imported does not match the number of columns in the table on SQL Data Warehouse.

    2.When logging in to SQL Data Warehouse server, the database can not be changed from the specified Master to any one

    3.A upper case and lower case is distinguished in an SQL statement

    ------------
    <In Japanese>
    ・ SQL…

    13 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 →
  6. 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

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

    We’ll send you updates on this idea

    1 comment  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  7. SSIS Data Profiling Task in Azure SQLDW

    Azure SQL DW does not support SSIS Profiling Task because PERMISSIONS function is not supported. It would be good if we would be able to profile data directly in ADW.

    10 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 →
  8. DWU Calculator

    In Azure SQL Database, we have DTU Calculator which helps to choose required DTU. Similarly, is there any plan to develop utility to determine required number of DWU or cDWU. I understand, that this is not straight forward as DTU.

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

    We’ll send you updates on this idea

    1 comment  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  9. Change - Exclusive lock queries wait until all select queries are complete

    Exclusive locks wait until all the select queries on the tables are completed.Instead if an option is given to switch between locking mechanism (i.e either use FIFO locking mechanism or the current locking mechanism)

    3 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 →
  10. Capability to monitor progress for transaction rollback

    Capability to monitor progress for transaction rollback

    3 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 →

    Thank you for the feedback. We are continuously improving the monitoring experience with SQL Data Warehouse. We will reach back out when this capability is on the roadmap and can share when we have an update.

  11. The ODBC function compatibility of SQL Data Warehouse with SQL Servers

    SQL Data Warehouse doesn't support some functions which SQL Server supports.
    For example,
    TIMESTAMPDIFF
    LENGTH
    LOCATE
    TRUNCATE

    I hope those functions are supported also on SQL DataWarehouse for migration.

    2 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 →
  12. Pipelines running continuously

    I'm having an issue where I've a pipeline which calls an SP on Azure SQL DW. I've set an interval of 15 minutes, however a new run starts as soon as one of the run finishes. It appears that it does not look at the interval.

    2 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 →
  13. create specific ADW documentation rather than referring us to SQL Server

    Case in point: https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-reference-tsql-system-views

    Just referring us to the SQL Server documentation is fine for the concept but then the examples do not work. See sys.dm_pdw_nodes_db_column_store_row_group_physical_stats which doesn't have documentation so you have no choice but to look at the similar page for SQL Server which has an example script for determining fragmentation only the object_id it returns from dm_pdw_nodes_db_column_store_row_group_physical_stats always evaluates via object_name to null so you have no way to determine the underlying table name!

    1 vote
    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 →
  14. Need provision to add message when resume/pause requested

    At the moment can get the resume/pause activities through activity log in Azure Portal.

    If there is provision to add message when paused/ resumed it would be helpful to trace back the on demand pause/resume requests happened over the time when audit happens.

    1 vote
    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 →
  15. It's not clear how to legally connect via ODBC

    In the Microsoft Azure SQL Data Warehouse documentation it says that you can connect to the instance using ODBC. However, the link to the ODBC driver is to a driver with a licence which is for software design, development and test.

    It's not clear whether there is an ODBC driver in existence for production use.

    1 vote
    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 →
  • Don't see your idea?

Feedback and Knowledge Base