azure-powershell-task-get-sql-access-token.yml

# Azure PowerShell 
# https://docs.microsoft.com/en-us/azure/devops/pipelines/tasks/deploy/azure-powershell?view=azure-devops
# Run a PowerShell script within an Azure environment
- task: AzurePowerShell@5
  inputs:
    azureSubscription: <YourServiceConnection> # Required. Name of Azure Resource Manager service connection
    scriptType: 'inlineScript' # Optional. Options: filePath, inlineScript
    #scriptPath: # Optional
    inline: | # '# You can write your Azure PowerShell scripts inline here. # You can also pass predefined and custom variables to this script using arguments' # Optional
      # Import needed modules
      Import-Module SQLServer
      Import-Module Az.Accounts -MinimumVersion 2.2.0

      # Get an access token with the Service Pricipal used in the Azure DevOps Pipeline
      $access_token = (Get-AzAccessToken -ResourceUrl https://database.windows.net).Token

      $ServerInstance   = <myserver.database.windows.net> 
      $database_name    = <mydatabase> 
      $query            = <SELECT * FROM dbo.Table>

      # Execute the query on the SQL Serverless instance
      Invoke-Sqlcmd -ServerInstance $ServerInstance -Database $currentcon -AccessToken $access_token -query $query  

    #scriptArguments: # Optional
    #errorActionPreference: 'stop' # Optional. Options: stop, continue, silentlyContinue
    #failOnStandardError: false # Optional
    azurePowerShellVersion: 'latestVersion' # Required. Options: latestVersion, otherVersion
    #preferredAzurePowerShellVersion: # Required when azurePowerShellVersion == OtherVersion
    #pwsh: true # Optional. If true, then will use PowerShell Core pwsh.exe