An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
Synapse demo script generate error
Sedat Turan
0
Reputation points
The demo link "Analyze data in a lake database demo" below produces an error https://microsoftlearning.github.io/dp-203-azure-data-engineer/Instructions/Labs/04-Create-a-Lake-Database.html
DeploymentDebugLogLevel :
Granting permissions on the datalake5ixmtpr storage account...
(you can ignore any warnings!)
ERROR: Failed to connect to MSI. Please make sure MSI is configured correctly.
Get Token request returned: <Response [400]>
Get-AzADServicePrincipal_List: /usr/local/share/powershell/Modules/Az.Resources/6.13.0/MSGraph.Autorest/custom/Get-AzADServicePrincipal.ps1:221
Line |
221 | Az.MSGraph.internal\Get-AzADServicePrincipal @PSBoundParameters
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| ManagedIdentityCredential authentication failed: Service request failed. Status: 400 (Bad Request) Content: Headers: X-Powered-By: REDACTED ETag:
| W/"7e-AtyJbQt9VqLG5RxtNN/7cqAVKqA" Date: Tue, 23 Jan 2024 10:30:27 GMT Connection: keep-alive Keep-Alive: REDACTED Content-Type: application/json;
| charset=utf-8 Content-Length: 126 See the troubleshooting guide for more information.
| https://aka.ms/azsdk/net/identity/managedidentitycredential/troubleshoot
New-AzRoleAssignment: /home/sedat/dp-203/Allfiles/labs/04/setup.ps1:158
Line |
158 | New-AzRoleAssignment -Objectid $id -RoleDefinitionName "Storage Blob …
| ~~~
| Cannot validate argument on parameter 'ObjectId'. The argument is null or empty. Provide an argument that is not null or empty, and then try the command
| again.
New-AzRoleAssignment: /home/sedat/dp-203/Allfiles/labs/04/setup.ps1:159
Line |
159 | New-AzRoleAssignment -SignInName $userName -RoleDefinitionName "Stora …
| ~~~~~~~~~
| Cannot validate argument on parameter 'SignInName'. The argument is null or empty. Provide an argument that is not null or empty, and then try the command
| again.
Script completed at 01/23/2024 10:30:28
Azure Synapse Analytics
Azure Synapse Analytics
Sign in to answer