Databricks AI Agents Calling External API

Databricks Mosaic AI Agents: Instead of analyzing data, agents can send alerts, create Jira tickets, or trigger workflows in external systems. That’s all thanks to the recently added SQL http_request() function. So let’s see how an agent can open the Jira task that the server is burning.

If you are not yet a member of Medium, you can access for free via a friend’s link

Create a Connection to the External Service

We use a simple CREATE CONNECTION command to set up a connection with our external service. This is the same way we’ve been adding connections to Lakehouse Federation. This might be Jira or a similar service in real scenarios, but I will use a request bin for that experiment.

CREATE CONNECTION alert
  TYPE HTTP
  OPTIONS (
    host 'https://eoohomz6hb9petw.m.pipedream.net',
    port '443',
    base_path '/',
    bearer_token 'bin'
  );

We can achieve the same through AI in Unity Catalog:

Send a Request to the External Service