Greg Galloway

My feedback

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

    We’ll send you updates on this idea

    0 comments  ·  Azure Analysis Services  ·  Flag idea as inappropriate…  ·  Admin →
    Greg Galloway supported this idea  · 
  2. 9 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Azure Analysis Services  ·  Flag idea as inappropriate…  ·  Admin →
    Greg Galloway shared this idea  · 
  3. 2 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL Data Warehouse » Security  ·  Flag idea as inappropriate…  ·  Admin →
    Greg Galloway shared this idea  · 
  4. 10 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  SQL Data Warehouse » Performance  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you for voting for this feature! We are aware of this scenario and are looking into ways of supporting this and improving our query troubleshooting experience. In the meantime, stay tuned for an update and please continue voting for this feature.

    Greg Galloway supported this idea  · 
  5. 43 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  SQL Data Warehouse » Management  ·  Flag idea as inappropriate…  ·  Admin →
    Greg Galloway supported this idea  · 
  6. 33 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    17 comments  ·  SQL Data Warehouse » Polybase  ·  Flag idea as inappropriate…  ·  Admin →
    Greg Galloway supported this idea  · 
  7. 10 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  SQL Data Warehouse » Management  ·  Flag idea as inappropriate…  ·  Admin →
    Greg Galloway supported this idea  · 
    Greg Galloway commented  · 

    I did some research on this and totally agree. It seems like a very small enhancement to SQL DW would be all that's needed.

    If SQL DW could add support for the following GRANT statement then we could do ADF and Polybase with reasonable permissions. Please support:

    GRANT ALTER ANY DATABASE SCOPED CREDENTIAL to adf_user

    Once that is done, then the following existing grants which are currently working will provide enough permissions to ADF to use Polybase I think:

    --if some admin has previously run CREATE MASTER KEY then all ADF needs is to select from sys.symmetric_keys where symmetric_key_id = 101 to confirm that's done already
    GRANT VIEW DEFINITION TO adf_user

    --allows ADF to create a new external data source
    GRANT ALTER ANY EXTERNAL DATA SOURCE TO adf_user

    --allows ADF to create a new external file format
    GRANT ALTER ANY EXTERNAL FILE FORMAT TO adf_user

    --gives ADF permissions needed to the dbo schema where ADF currently puts external tables
    GRANT ALTER ON SCHEMA::dbo TO adf_user

    --gives ADF permissions to create an external table
    GRANT CREATE TABLE TO adf_user

  8. 13 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Data Factory  ·  Flag idea as inappropriate…  ·  Admin →
    Greg Galloway commented  · 

    One scenario we could use this is creating a second DW and copying a subset of tables from DW1 to DW2 via ADF Copy Wizard (which should export to blob and then import from blob). This can be common with large enterprises which have hub and spoke DWs.

    There are dozens of reasons you may want to export from SQL DW to blob. Please optimize it so it runs fast using Polybase.

    Greg Galloway shared this idea  · 
  9. 11 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL Data Warehouse » T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
    Greg Galloway supported this idea  · 
  10. 43 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  SQL Data Warehouse » Management  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you for voting for this feature. We understand this scenario and will consider this in a future release. For now, please continue monitoring this item and have your team vote for this feature. Thank you for your patience.

    Greg Galloway supported this idea  · 
  11. 900 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    started  ·  97 comments  ·  SQL Data Warehouse » Integration  ·  Flag idea as inappropriate…  ·  Admin →
    Greg Galloway supported this idea  · 
  12. 91 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    planned  ·  5 comments  ·  Azure Analysis Services  ·  Flag idea as inappropriate…  ·  Admin →
    Greg Galloway supported this idea  · 
  13. 15 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Automation » Source control integration  ·  Flag idea as inappropriate…  ·  Admin →
    Greg Galloway supported this idea  · 
  14. 181 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    14 comments  ·  Azure Analysis Services  ·  Flag idea as inappropriate…  ·  Admin →
    Greg Galloway shared this idea  · 
  15. 81 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    7 comments  ·  Azure Analysis Services  ·  Flag idea as inappropriate…  ·  Admin →
    Greg Galloway shared this idea  · 
  16. 23 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Azure Analysis Services  ·  Flag idea as inappropriate…  ·  Admin →
    Greg Galloway supported this idea  · 
  17. 706 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    46 comments  ·  Azure Analysis Services  ·  Flag idea as inappropriate…  ·  Admin →
    Greg Galloway supported this idea  · 
  18. 30 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  SQL Data Warehouse » Management  ·  Flag idea as inappropriate…  ·  Admin →

    We are actively improving our monitoring experience. Currently we have ‘DWU Used’ in the portal which is a blend between CPU and IO to indicate data warehouse utilization. We also have future improvements on our road map such as Query Data Store and integrating with Azure Monitor for near real time troubleshooting in the Azure portal. If anyone has any other feedback, please elaborate on your scenario on this thread. Thank you for your continued support!

    Greg Galloway supported this idea  · 
  19. 131 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    19 comments  ·  SQL Data Warehouse » Management  ·  Flag idea as inappropriate…  ·  Admin →
    Greg Galloway commented  · 

    There was a recent announcement of the Azure SQL Database Long-Term Retention feature. Maybe adding SQL DW support to that feature would accomplish this request?

    The current approach long term backup by restoring as a new DW that stays paused was a good idea until the premium storage switch. Now it's too expensive.

    Greg Galloway supported this idea  · 
  20. 28 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  SQL Data Warehouse » Other  ·  Flag idea as inappropriate…  ·  Admin →
    Greg Galloway supported this idea  · 

Feedback and Knowledge Base