Episode

Calling a REST service from Azure SQL DB | Data Exposed

with Anna Hoffman, Davide Mauri

With the new system-stored procedure sp_invoke_external_rest_endpoint, available in Azure SQL Database, it is possible to call any REST service inside and outside Azure, unlocking integration opportunities that would otherwise require much more effort and complexity. In this episode with Anna Hoffman and Davide Mauri, we will discuss the use cases and the inner workings of sp_invoke_external_rest_endpoint, so that you can have a deep understanding of how it works and when to use it, and how the engineering team created safe guardrails to make sure accessing external resources can be done safely and efficiently.

Chapters

  • 00:00 - Introduction
  • 00:52 - Why call a REST service from Azure SQL DB
  • 03:57 - Demo
  • 08:30 - Integration options
  • 12:34 - Getting started

Connect

Developer
Database Administrator
Data Engineer
Azure
Azure SQL Database
SQL