How do I run a query against an Azure SQL database?

This topic was automatically generated from Slack. You can find the original thread here.

MarkusDS : Can someone help with a sql snippet that can insert into a external SQL? I got one working without async, but I can’t seem to get it working with async

Dylan Sather (Pipedream) : Hi , which database are you working with?

MarkusDS : Hi Dylan, thanks for quick reply. it is an azure sql database

Dylan Sather (Pipedream) : great, I’d recommend taking a look at a guide like this: Use Node.js to query a database - Azure SQL Database & SQL Managed Instance | Microsoft Docs

Dylan Sather (Pipedream) : you can use a new Node.js code step to run any Node code, and that guide should walk you through the npm packages to use to construct your query

Dylan Sather (Pipedream) : In the section where you’re asked to npm install tedious (the package they use to run the query), you won’t need to on Pipedream. You can just require the package in the code, and Pipedream will install it for you.

MarkusDS : Hi Dylan, thanks i am also looking into the bastion, which we are using anyways for azure, thanks for all the help :slightly_smiling_face:

Dylan Sather (Pipedream) : great!