I've followed the instruction, the deployment finished but we some error in the last few steps. But ihave manually updated those on azure portal and updated source data to storage account. But the SQL DW(Synapse) instance doesn't have any table from the deployment. The post deploy script won't work

i.e Msg 15165, Level 16, State 1, Line 1
Could not find object 'Control' or you do not have permission.

There isn't a Control table created from deployment script

The deployment scripted failed at runing Set-SqlServerAADAdministrator, i've received below error

Script Executed with Errors - DeployOrchestrator

C:\src\NonprofitDataWarehouseQuickstart\Deployment\Scripts\Set-SqlServerAADAdministrator.ps1 : Cannot validate argument on parameter 'SqlServerAdmin'.
The argument is null or empty. Provide an argument that is not null or empty, and then try the command again.
At C:\src\NonprofitDataWarehouseQuickstart\Deployment\DeployOrchestrator.ps1:239 char:25

•     -SqlServerAdmin $AdminGroupName;
  

•                     ~~~~~~~~~~~~~~~
  

  • CategoryInfo : InvalidData: (:) [Set-SqlServerAADAdministrator.ps1], ParentContainsErrorRecordException
  • FullyQualifiedErrorId : ParameterArgumentValidationError,Set-SqlServerAADAdministrator.ps1

There are important files that Microsoft projects should all have that are not present in this repository. A pull request has been opened to add the missing file(s). When the pr is merged this issue will be closed automatically.

Microsoft teams can learn more about this effort and share feedback within the open source guidance available internally.

Merge this pull request

Script is failing @ Set-IamPermission, it just errors out no other details