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. Cross Database Querying

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

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

    We’ll send you updates on this idea

    planned  ·  11 comments  ·  SQL/Other  ·  Flag idea as inappropriate…  ·  Admin →
  2. [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…

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

    We’ll send you updates on this idea

    planned  ·  8 comments  ·  SQL/Loading  ·  Flag idea as inappropriate…  ·  Admin →
  3. DROP IF EXISTS

    Support DROP IF EXISTS

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

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

    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.

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

    We’ll send you updates on this idea

    1 comment  ·  SQL/Management  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base