Run sql scripts on azure synapse database

Copper Contributor

Hello,

 

Need to run SQL scripts on azure synapse database using azure powershell or azure cli, 

I have referred the Microsoft documentation, but didn't found command to run it.

can anyone help me on this. thank you

 

1 Reply

@sunildasari Hi Sunil! You can use the same tools to query dedicated or serverless pools, for example, invoke-sqlcmd with PowerShell, even sqlcmd. See also Connection strings for Synapse SQL. As for azure cli, see az synapse