Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

Reply
goreavin
Frequent Visitor

Fabric notebook development with an AI harness/LLM of your choice

I had a hard transformation to make.
Pandas was too slow.
Polars looked faster.
I wanted the machine to do the work.

 

The built-in copilot could not carry the load.
Too small. Too careful.
No frontier models. No long leash.

 

I could use the Pi harness to write the code.
That part was easy.
The hard part came after.

 

The notebook failed.
I read the errors.
I fixed the code.
I ran it again.

 

After a while, I became the bottleneck.

 

So I asked a simple question:

 

Is there a better way?

 

There was no clean way to expose Fabric notebooks to an external coding agent.
At least not officially.

 

But there was VS Code.
There was the Fabric CLI.

There was Livy.
There was the SQL analytics endpoint.

 

That felt like enough.

 

So I built around them.

 

The CLI edits the notebooks.
The CLI runs them too.
Livy works as well, though it fights you on lakehouse writes.

 

I added a custom Python tool.
Clanker generated it.
It catches cell-level execution and errors.

 

The harness reads the errors.
Tries again.
Runs again.
Repeats until the notebook executes cleanly.

 

Then the SQL endpoint checks the transformed data.

 

After that, I define test cases.
The harness keeps iterating until every test passes.

 

Closed loop.

 

The code is here: Link 

 

It works for me.

 

If you find sharper edges, smoother paths, or stranger failures, change it.
Commit your edge cases.
Let the next person suffer less.

1 REPLY 1
v-veshwara-msft
Community Support
Community Support

Hi @goreavin ,

Thanks for sharing this and contributing to the community.

Really appreciate the effort you put into documenting it. This will be helpful for others working on similar scenarios.

 

If you ever need assistance or have further questions, feel free to reach out or raise a new thread.

Keep engaging with the Fabric Community.

 

Best Regards,
Vinay.

Helpful resources

Announcements
April Fabric Update Carousel

Fabric Monthly Update - April 2026

Check out the April 2026 Fabric update to learn about new features.

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.