Create or update the silver, gold and check pipeline in Fabric (dry run by default)
create_pipelineCreates the pipeline export_item_definitions drafts with items=["pipeline"]: the silver and gold notebooks of create_silver_notebook and create_gold_views, a check notebook, and a data pipeline that runs them in that order, each only after the one before succeeded, so a failed check fails the run. Items of these names are updated in place. Requires workspace, a lakehouse source with schemas and name; Notebook.ReadWrite.All and DataPipeline.ReadWrite.All (or Item.ReadWrite.All), and Contributor. Returns JSON with the definitions and REST calls; with dry_run=false also each step's result. Changes Fabric only with dry_run=false: four definitions are replaced, nothing is deleted, nothing runs and no schedule is added. Errors: {error, kind, hint}.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"workspace": "<workspace>",
"source": "<source>",
"name": "<name>"
},
"name": "create_pipeline"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| keys | No | Primary keys replacing the inferred ones. Default: inferred. Example: {"order_items": ["order_id", "line_no"]}. | |
| name | Yes | Display name of the pipeline; its check notebook is <name>_check. Existing items with these names are updated in place. Example: "pipeline_shop". | |
| schema | No | Schema in the source. Default "dbo". | dbo |
| source | Yes | Lakehouse, warehouse or SQL database, name or id. | |
| tables | No | Exact table names to include. Default all. | |
| dry_run | No | true (default) returns what would be created and the REST calls, changing nothing; false creates or updates. | |
| confirmed | No | Relationships the user confirmed, added to the plan. Default none. Example: [{"source": "orders", "source_cols": ["ship_to_id"], "target": "addresses", "target_cols": ["address_id"]}]. | |
| gold_name | No | Display name of the gold views notebook the pipeline runs, updated in place if it exists. Default "" (gold_<schema>). Example: "gold_shop". | |
| workspace | Yes | Fabric workspace, name or id. | |
| gold_schema | No | Lakehouse schema for the gold views. Default "gold". Example: "gold". | gold |
| silver_name | No | Display name of the silver notebook the pipeline runs, updated in place if it exists. Default "" (silver_<schema>). Example: "silver_shop". | |
| silver_schema | No | Lakehouse schema with the silver tables create_silver_notebook writes. Default "silver". | silver |
| show_personal_data | No | true includes columns named like personal data; false (default) masks or omits them. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |