Edit The JSON of a Fabric Pipeline

Comments 0

Share to social media

A Fabric Pipeline uses JSON as source code. They are also saved in repositories as JSON.

We first idea we get is editing the pipeline in JSON format. We can copy the JSON and create new pipelines with small variations, making changes directly on the JSON.

However, at first sight we get disappointed, because the pipeline doesn’t allow the JSON to be edited. We have the option to view the JSON, but nothing else.

A screenshot of a computer

Description automatically generated

The Big Pipeline Secret

There is a special parameter we should add to the URL to make the pipeline editable.

This is what you need to add:

&feature.enableJsonEdit=1

Of course, you need to follow the rules of URL parameters: use ‘&’ if this is not the first parameter (and probably isn’t) or use ‘?’ if this is the first parameter.

The magic will appear: The button becomes an “Edit” button, allowing us to Edit the JSON in many ways as our creativity demands.

A screenshot of a computer

Description automatically generated

Conclusion

This hidden secret is difficult to discover, but it can prove to be extremely useful.

Take a look on this video to check how it works: Fabric Monday 32: Edit Pipeline’s JSON

 

Load comments

About the author

Dennes Torres

See Profile

Dennes Torres is a Data Platform MVP and Software Architect living in Malta who loves SQL Server and software development and has more than 20 years of experience. Dennes can improve Data Platform Architectures and transform data in knowledge. He moved to Malta after more than 10 years leading devSQL PASS Chapter in Rio de Janeiro and now is a member of the leadership team of MMDPUG PASS Chapter in Malta organizing meetings, events, and webcasts about SQL Server. He is an MCT, MCSE in Data Platforms and BI, with more titles in software development. You can get in touch on his blog https://dennestorres.com or at his work https://dtowersoftware.com