Azure Data Lake Storage Gen2 overview

The Discussion

• 

  I like the content but, not so much delivery. This guy is too casual for internet scale presentation.
  
  I cannot hear him well even though my speakers are maxed out. His phrases fade out at the end. Too casual.
  I suppose the outfit must match the presentation.
  

• 

  Hi Joel - I'm sorry you're not happy with the informality of Azure Friday. The format of the show is an engineer to engineer conversation, so we don't script the show and guest performance varies as people do. If you're having difficulty with sound level (not able to repro here) you can turn on captions, which also make the content accessible for many languages.

• 

  cmon guys, he is an Aussie, doesnt get more formal

• 

  Azure SQL data warehouse Polybase with Azure Storage datalake Gen2 is not working with MSI at folder level however it is working with role base access.
  
  I am getting below error "This request is not authorized to perform this operation using this permission" with MSI where access has been given to MSI at folder level.
  
  
  Appreciate your response

• 

  From James Baker:
  
  I am able to confirm that Azure SQL Data Warehouse’s Polybase capability does indeed work in being able to reference data in ADLS Gen2 using the system-assigned MSI when that MSI only has ACL access and not RBAC access.
  
  There are 2 things to consider when applying ACLs in ADLS Gen2:
  
  1. Irrespective on where the MSI is granted read ‘R’ and/or write ‘W’ access, the principal MUST have execute ‘X’ permission from the root directory all the way down to the data directory. This allows the MSI to traverse the directory structure and will fail without this permission.
  
  2. The ‘Principal ID’ of the MSI must be the guid value specified in the ACL. This can be obtained using the Powershell ‘Get-AzSqlServer’ cmdlet.
  

• 

  this was exactly what I was looking for. A great presentation!