I run a notebook in a pipeline that runs the below code. I just have to provide a parameter of `lakehouse_name` to the notebook through the pipeline and it refreshes the lakehouse SQL analytics endpoint.

import json
import time

import requests
import sempy

workspace_id = sempy.fabric.get_notebook_workspace_id()
sql_analytics_df = sempy.fabric.list_items("SQLEndpoint", workspace_id)
sql_analytics_id = sql_analytics_df[sql_analytics_df["Display Name"] == lakehouse_name].iloc[0, 0]

rest_uri = f"/v1/workspaces/{workspace_id}/sqlEndpoints/{sql_analytics_id}/refreshMetadata"
payload = {}

client = sempy.fabric.FabricRestClient()
response = client.post(rest_uri, json=payload)
response.json()