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.

Andy Steinke

My feedback

  1. 185 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

    35 comments  ·  Azure Synapse Analytics » SQL/Management  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Andy Steinke commented  · 

    We have dev, stage, and prod subscriptions and having to perform these extra steps just adds delay, failure points, and frustration. Many companies of reasonable size will have multiple data warehouse environments and it should be almost as easy to restore prod to stage or dev as it is in good old fashioned SQL....

    Andy Steinke supported this idea  · 
  2. 423 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

    under review  ·  32 comments  ·  Azure Synapse Analytics » SQL/Polybase  ·  Flag idea as inappropriate…  ·  Admin →
    Andy Steinke supported this idea  · 
    An error occurred while saving the comment
    Andy Steinke commented  · 

    Polybase is a critical method for importing data into the warehouse and accessing data through a SQL interface and in order to fully utilize delta lake files it is a major hindrance. Thank you and we appreciate prioritizing this critical effort!

  3. 35 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Data Factory  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Andy Steinke commented  · 

    In addition we would like to be able to encrypt files that we need to send to outside parties.

    Andy Steinke supported this idea  · 
  4. 31 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Data Factory  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Andy Steinke commented  · 

    Is there any solution planned for ADF? We have the need to encrypt an output file before sending it to a vendor and would like to be able to do it easily within the pipeline.

    Andy Steinke supported this idea  · 
  5. 120 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Data Factory  ·  Flag idea as inappropriate…  ·  Admin →
    Andy Steinke supported this idea  · 
  6. 29 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  ·  Azure Synapse Analytics » SQL/Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Andy Steinke commented  · 

    Enforced unique constraints are an accepted data warehouse design pattern and it acts as an excellent low code data quality layer. In most cases we would prefer to handle the problem during ETL as opposed to after the data has already been duplicated. Thank you for any priority you can place on this feature!

    Andy Steinke supported this idea  · 
  7. 132 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

    An error occurred while saving the comment
    Andy Steinke commented  · 

    This is a key component of helping Synapse becoming unified analytics platform.

    This may be related to this suggestion to add delta lake support to polybase.

    https://feedback.azure.com/forums/307516-azure-synapse-analytics/suggestions/39108379-add-support-for-delta-lake-file-format-in-azure

    Andy Steinke supported this idea  · 
  8. 901 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  27 comments  ·  Data Factory  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Andy Steinke commented  · 

    This is definitely a needed feature that would greatly simplify common development problems.

    Andy Steinke supported this idea  · 

Feedback and Knowledge Base