Forum Discussion

ssisjoost's avatar
ssisjoost
Copper Contributor
Dec 20, 2023

Get token for Synapse Serverless SQL pool

I want to get a token from the Synapse Serverless SQL pool, but it is unknown which resource (/audience) to use for verifying.           $token= & az account get-access-token --resource=ht...
_MartinB's avatar
_MartinB
Iron Contributor
Dec 29, 2023

ssisjoost 
for me the following works:

$accessToken = (Get-AzAccessToken -ResourceUrl "https://database.windows.net").Token
$server = "$($synapseWorkspaceName)-ondemand.sql.azuresynapse.net"
$database = "master"

$ResponeCheckDbType = Invoke-Sqlcmd -ServerInstance $server -Database $database -AccessToken $accessToken -Query "SELECT 1 AS some"
Write-Verbose $ResponeCheckDbType.some

 

  • Get-AzAccessToken:
    https://learn.microsoft.com/en-us/powershell/module/az.accounts/get-azaccesstoken?view=azps-11.1.0
  • Invoke-Sqlcmd:
    https://learn.microsoft.com/de-de/powershell/module/sqlserver/invoke-sqlcmd?view=sqlserver-ps 

Make sure that the user / service principal executing the script has required Server / Database roles assigned.

Resources