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: Documentation, MSDN forum, and StackOverflow. If you need support, please open a support ticket.

Suggest an idea for a new or improved feature!

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback

  1. SQL Data Tools for Synaspe Serverless

    https://cloudblogs.microsoft.com/sqlserver/2019/11/07/new-in-azure-synapse-analytics-cicd-for-sql-analytics-using-sql-server-data-tools/ describes how SQL Server Data Tools support for Synapse not mentioning that this is only for Dedicated Pools. We need similar support for Synapse Serverless as well otherwise CI/CD will be hard to handle.

    8 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    planned  ·  0 comments  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →

  2. Export query result in SQL on-demand to external storage in Synapse Studio

    Currently synapse workspace doesn't support to create a linked service specifically for SQL on-demand. Thus since we were unable to create a dataset for it without linked service, we cannot leverage the copy activity in ADF pipeline to export data in SQL on-demand to storage account.
    The current workaround for this issue is to create a linked service as Azure SQL database and manually add SQL on-demand endpoint as the server name.

    However we were wondering if it is possible to add a type of linked service specifically for SQL on-demand, or if it is possible to add a note…

    2 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    planned  ·  0 comments  ·  Workspace/Pipelines  ·  Flag idea as inappropriate…  ·  Admin →

  3. Add Scalar UDF support to Azure Synapse Analytics - Serverless SQL Pool

    Right now, Azure Synapse Analytics does not support UDF functions in Serverless SQL Pool.
    It would be really beneficial to have UDFs working in Serverless SQL Pool

    2 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    planned  ·  0 comments  ·  Flag idea as inappropriate…  ·  Admin →

  4. Auditing for Serverless SQL Pool

    Currently, only dedicated SQL is capable of auditing. For high compliance requirements, serverless SQL Pool needs to have auditing capabilities.

    2 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    planned  ·  0 comments  ·  Flag idea as inappropriate…  ·  Admin →

  5. Serverless Synapse Create External Table from CSV

    On a Serverless Synapse workspace, when I go to linked tab, I can right click on a parquet file and I get an option to "create external table", when I follow this same steps for a CSV file I do not get the option to "create external table". Can we make this option available for CSV files too?

    1 vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    planned  ·  0 comments  ·  SQL/Polybase  ·  Flag idea as inappropriate…  ·  Admin →

  6. 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)
    Close
    Close

    We’ll send you updates on this idea

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

  7. DROP IF EXISTS

    Support DROP IF EXISTS

    80 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    planned  ·  0 comments  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →

  8. Cross Database Querying

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

    252 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    planned  ·  11 comments  ·  SQL/Other  ·  Flag idea as inappropriate…  ·  Admin →

  9. Expand size of LABEL in query logs

    The LABEL column in the sys.dmpdwexec_requests DMV is limited to 255 characters.

    This field needs to be much larger to store rich metadata/context of some queries.

    4 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    1 comment  ·  SQL/Management  ·  Flag idea as inappropriate…  ·  Admin →

  10. Backup on Pause/Resume

    At the moment the automated backup process take place every 8 hours unless the database is paused. Upon resumption of the database, it appears that it has to be online for 8 hours before the next backup is taken.

    If resuming and then pausing the system again it is possible to go for a long duration without backups. Could you please evaluate the potential of taking an automatic backup either when the database is paused or resumed.

    14 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  SQL/Management  ·  Flag idea as inappropriate…  ·  Admin →
    planned  ·  AdminAzure Synapse Team (Admin, Microsoft Azure) responded

    We are actively exploring ways to enable event-driven backups. Currently this scenario can be addressed by User Defined Restore Points which is on our road map for this calendar year. Stay tuned and thank you for your patience.

  11. [In preview] More flexible date formats in Polybase

    This feedback item is currently in preview here:

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

    Polybase currently has very limited date format support. All of the acceptable date formats have dashes or slashes. For example, I can't define a date format of yyyyMMdd since it doesn't have slashes or dashes. Please allow any date format I can express.

    Also, please allow more than one date format per external table. For example, what if I have a date column as yyyyMMdd and then a different column as yyyyMMddHHmm. With only being able to define one date format in the CREATE EXTERNAL FILE FORMAT statement I think I…

    82 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    planned  ·  8 comments  ·  SQL/Loading  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Azure Synapse Analytics

Categories

Feedback and Knowledge Base

(thinking…)
Hosted by UserVoice