Lakehouse delta Table maintenance API request

[Thyagarajulu99]

Dear Team,

We are planning to automate Delta table maintenance options via Fabric requests and need your support with detailed steps to fulfil this requirement.

Our plan is to use Azure Logic Apps to process the API requests. However, we are uncertain about how to authenticate the Fabric service using a service principal or managed identity. 

It would be great if you provide the details solution for it.

[v-yilong-msft]

Hi @Thyagarajulu99 ,

Based on my understanding of your question, I think you can refer to the following official document, maybe it will help you:

Delta table maintenance in Microsoft Fabric - Microsoft Fabric | Microsoft Learn

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AndyDDC · Accepted solution]

You could just use a Spark job:

Using Spark Jobs for Multiple Lakehouse Maintenance in Microsoft Fabric - Simple Talk

[R1k91]

why don't you do the maintenance in a notebook and you schedule it via Data Pipelines?
you've already everything you need in Fabric, why do you use LogicApp?