rm -r dp-203 -f
git clone https://github.com/MicrosoftLearning/dp-203-azure-data-engineer dp-203
cd dp-203/Allfiles/labs/01
./setup.ps1
Starting script at 04/26/2023 08:48:19
Enter a password to use for the SQLUser login.
The password must meet complexity requirements:
- Minimum 8 characters.
- At least one upper case English letter [A-Z]
- At least one lower case English letter [a-z]
- At least one digit [0-9]
- At least one special character (!,@,#,%,^,&,$)
: Data123#
Password Data123# accepted. Make sure you remember this!
Registering resource providers...
Microsoft.Synapse : Registered
Microsoft.Sql : Registered
Microsoft.Storage : Registered
Microsoft.Compute : Registered
Your randomly-generated suffix for Azure resources is x3vf5wy
Finding an available region. This may take several minutes...
Trying centralus
Using centralus
Creating dp203-x3vf5wy resource group in centralus ...
Creating synapsex3vf5wy Synapse Analytics workspace in dp203-x3vf5wy resource group...
(This may take some time!)
New-AzResourceGroupDeployment: /home/cstx_a_schleh/dp-203/Allfiles/labs/01/setup.ps1:141
Line |
141 | New-AzResourceGroupDeployment -ResourceGroupName $resourceGroupName `
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| 8:51:29 AM - Error: Code=InvalidTemplateDeployment; Message=Deployment failed with multiple errors: 'Authorization failed for template resource 'datalakex3vf5wy/default/files/Microsoft.Authorization/3aab02e9-9b0b-54ec-a155-85f5f652faaf' of type
| 'Microsoft.Storage/storageAccounts/blobServices/containers/providers/roleAssignments'. The client '[email protected]' with object id 'cef3760c-22e4-488d-8d37-0a4007bb6fe4' does not have permission to perform action
| 'Microsoft.Authorization/roleAssignments/write' at scope
| '/subscriptions/ac7d4266-c54a-41d0-970b-5ba5bf9ddfae/resourceGroups/dp203-x3vf5wy/providers/Microsoft.Storage/storageAccounts/datalakex3vf5wy/blobServices/default/containers/files/providers/Microsoft.Authorization/roleAssignments/3aab02e9-9b0b-54ec-a155-85f5f652faaf'.:Authorization failed for template resource '95a444ef-4c02-5c8c-92e5-5541883279ee' of type 'Microsoft.Authorization/roleAssignments'. The client '[email protected]' with object id 'cef3760c-22e4-488d-8d37-0a4007bb6fe4' does not have permission to perform action 'Microsoft.Authorization/roleAssignments/write' at scope '/subscriptions/ac7d4266-c54a-41d0-970b-5ba5bf9ddfae/resourceGroups/dp203-x3vf5wy/providers/Microsoft.Authorization/roleAssignments/95a444ef-4c02-5c8c-92e5-5541883279ee'.'
New-AzResourceGroupDeployment: /home/cstx_a_schleh/dp-203/Allfiles/labs/01/setup.ps1:141
Line |
141 | New-AzResourceGroupDeployment -ResourceGroupName $resourceGroupName `
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| The deployment validation failed
Pausing the adxx3vf5wy Data Explorer Pool...
Stop-AzSynapseKustoPool: /home/cstx_a_schleh/dp-203/Allfiles/labs/01/setup.ps1:156
Line |
156 | Stop-AzSynapseKustoPool -Name $adxpool -ResourceGroupName $resourceGr …
| ~~~~~~~~~~~~~~~~~~~~~~~
| The 'Stop-AzSynapseKustoPool' command was found in the module 'Az.Synapse', but the module could not be loaded. For more information, run 'Import-Module Az.Synapse'.
Granting permissions on the datalakex3vf5wy storage account...
(you can ignore any warnings!)
New-AzRoleAssignment: /home/cstx_a_schleh/dp-203/Allfiles/labs/01/setup.ps1:164
Line |
164 | 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.
Creating the sqlx3vf5wy database...
Sqlcmd: Error: Microsoft ODBC Driver 18 for SQL Server : Login timeout expired.
Sqlcmd: Error: Microsoft ODBC Driver 18 for SQL Server : TCP Provider: Error code 0x2AF9.
Sqlcmd: Error: Microsoft ODBC Driver 18 for SQL Server : A network-related or instance-specific error has occurred while establishing a connection to synapsex3vf5wy.sql.azuresynapse.net. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online..
Loading data...
/home/cstx_a_schleh/dp-203/Allfiles/labs/01/data/DimCurrency.txt
SQLState = S1T00, NativeError = 0
Error = [Microsoft][ODBC Driver 18 for SQL Server]Login timeout expired
SQLState = 08001, NativeError = 11001
Error = [Microsoft][ODBC Driver 18 for SQL Server]TCP Provider: Error code 0x2AF9
SQLState = 08001, NativeError = 11001
Error = [Microsoft][ODBC Driver 18 for SQL Server]A network-related or instance-specific error has occurred while establishing a connection to synapsex3vf5wy.sql.azuresynapse.net. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.
/home/cstx_a_schleh/dp-203/Allfiles/labs/01/data/DimCustomer.txt
SQLState = S1T00, NativeError = 0
Error = [Microsoft][ODBC Driver 18 for SQL Server]Login timeout expired
SQLState = 08001, NativeError = 11001
Error = [Microsoft][ODBC Driver 18 for SQL Server]TCP Provider: Error code 0x2AF9
SQLState = 08001, NativeError = 11001
Error = [Microsoft][ODBC Driver 18 for SQL Server]A network-related or instance-specific error has occurred while establishing a connection to synapsex3vf5wy.sql.azuresynapse.net. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.
/home/cstx_a_schleh/dp-203/Allfiles/labs/01/data/DimDate.txt
SQLState = S1T00, NativeError = 0
Error = [Microsoft][ODBC Driver 18 for SQL Server]Login timeout expired
SQLState = 08001, NativeError = 11001
Error = [Microsoft][ODBC Driver 18 for SQL Server]TCP Provider: Error code 0x2AF9
SQLState = 08001, NativeError = 11001
Error = [Microsoft][ODBC Driver 18 for SQL Server]A network-related or instance-specific error has occurred while establishing a connection to synapsex3vf5wy.sql.azuresynapse.net. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.
/home/cstx_a_schleh/dp-203/Allfiles/labs/01/data/DimGeography.txt
SQLState = S1T00, NativeError = 0
Error = [Microsoft][ODBC Driver 18 for SQL Server]Login timeout expired
SQLState = 08001, NativeError = 11001
Error = [Microsoft][ODBC Driver 18 for SQL Server]TCP Provider: Error code 0x2AF9
SQLState = 08001, NativeError = 11001
Error = [Microsoft][ODBC Driver 18 for SQL Server]A network-related or instance-specific error has occurred while establishing a connection to synapsex3vf5wy.sql.azuresynapse.net. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.
/home/cstx_a_schleh/dp-203/Allfiles/labs/01/data/DimProduct.txt
SQLState = S1T00, NativeError = 0
Error = [Microsoft][ODBC Driver 18 for SQL Server]Login timeout expired
SQLState = 08001, NativeError = 11001
Error = [Microsoft][ODBC Driver 18 for SQL Server]TCP Provider: Error code 0x2AF9
SQLState = 08001, NativeError = 11001
Error = [Microsoft][ODBC Driver 18 for SQL Server]A network-related or instance-specific error has occurred while establishing a connection to synapsex3vf5wy.sql.azuresynapse.net. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.
/home/cstx_a_schleh/dp-203/Allfiles/labs/01/data/DimProductCategory.txt
SQLState = S1T00, NativeError = 0
Error = [Microsoft][ODBC Driver 18 for SQL Server]Login timeout expired
SQLState = 08001, NativeError = 11001
Error = [Microsoft][ODBC Driver 18 for SQL Server]TCP Provider: Error code 0x2AF9
SQLState = 08001, NativeError = 11001
Error = [Microsoft][ODBC Driver 18 for SQL Server]A network-related or instance-specific error has occurred while establishing a connection to synapsex3vf5wy.sql.azuresynapse.net. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.
/home/cstx_a_schleh/dp-203/Allfiles/labs/01/data/DimProductSubCategory.txt
SQLState = S1T00, NativeError = 0
Error = [Microsoft][ODBC Driver 18 for SQL Server]Login timeout expired
SQLState = 08001, NativeError = 11001
Error = [Microsoft][ODBC Driver 18 for SQL Server]TCP Provider: Error code 0x2AF9
SQLState = 08001, NativeError = 11001
Error = [Microsoft][ODBC Driver 18 for SQL Server]A network-related or instance-specific error has occurred while establishing a connection to synapsex3vf5wy.sql.azuresynapse.net. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.
/home/cstx_a_schleh/dp-203/Allfiles/labs/01/data/DimPromotion.txt
SQLState = S1T00, NativeError = 0
Error = [Microsoft][ODBC Driver 18 for SQL Server]Login timeout expired
SQLState = 08001, NativeError = 11001
Error = [Microsoft][ODBC Driver 18 for SQL Server]TCP Provider: Error code 0x2AF9
SQLState = 08001, NativeError = 11001
Error = [Microsoft][ODBC Driver 18 for SQL Server]A network-related or instance-specific error has occurred while establishing a connection to synapsex3vf5wy.sql.azuresynapse.net. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.
/home/cstx_a_schleh/dp-203/Allfiles/labs/01/data/DimSalesTerritory.txt
SQLState = S1T00, NativeError = 0
Error = [Microsoft][ODBC Driver 18 for SQL Server]Login timeout expired
SQLState = 08001, NativeError = 11001
Error = [Microsoft][ODBC Driver 18 for SQL Server]TCP Provider: Error code 0x2AF9
SQLState = 08001, NativeError = 11001
Error = [Microsoft][ODBC Driver 18 for SQL Server]A network-related or instance-specific error has occurred while establishing a connection to synapsex3vf5wy.sql.azuresynapse.net. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.
/home/cstx_a_schleh/dp-203/Allfiles/labs/01/data/FactInternetSales.txt
SQLState = S1T00, NativeError = 0
Error = [Microsoft][ODBC Driver 18 for SQL Server]Login timeout expired
SQLState = 08001, NativeError = 11001
Error = [Microsoft][ODBC Driver 18 for SQL Server]TCP Provider: Error code 0x2AF9
SQLState = 08001, NativeError = 11001
Error = [Microsoft][ODBC Driver 18 for SQL Server]A network-related or instance-specific error has occurred while establishing a connection to synapsex3vf5wy.sql.azuresynapse.net. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.
Pausing the sqlx3vf5wy SQL Pool...
Suspend-AzSynapseSqlPool: /home/cstx_a_schleh/dp-203/Allfiles/labs/01/setup.ps1:184
Line |
184 | Suspend-AzSynapseSqlPool -WorkspaceName $synapseWorkspace -Name $sqlD …
| ~~~~~~~~~~~~~~~~~~~~~~~~
| The 'Suspend-AzSynapseSqlPool' command was found in the module 'Az.Synapse', but the module could not be loaded. For more information, run 'Import-Module Az.Synapse'.
Loading data...
Get-AzStorageAccount: /home/cstx_a_schleh/dp-203/Allfiles/labs/01/setup.ps1:188
Line |
188 | … geAccount = Get-AzStorageAccount -ResourceGroupName $resourceGroupNam …
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| The Resource 'Microsoft.Storage/storageAccounts/datalakex3vf5wy' under resource group 'dp203-x3vf5wy' was not found. For more details please go to https://aka.ms/ARMResourceNotFoundFix
sales.csv
Set-AzStorageBlobContent: /home/cstx_a_schleh/dp-203/Allfiles/labs/01/setup.ps1:195
Line |
195 | Set-AzStorageBlobContent -File $_.FullName -Container "files" -Bl …
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Could not get the storage context. Please pass in a storage context or set the current storage context.
Script completed at 04/26/2023 08:54:11
PS /home/cstx_a_schleh/dp-203/Allfiles/labs/01>