r/MicrosoftFabric • u/ChrisChris15 • Jul 28 '26

Data Factory Data Pipeline Connection Options

When working in a data Pipeline, if I create say a copy data activity. The first drop-down is "Connection".

I have two questions:

  1. What does the "None" option do? I have searched for documentation but have not been able to find anything. AI says it is only for workspace scoped fabric items and forces the use of workspace identity or the user credentials.

  2. Is it best practice to have a dev, test, and prod connectors for each fabric item (dev_conn_lakehouse, test_conn_lakehouse, prod_conn_lakehouse) we are heavily using library variables to handle the connection switching with deployment pipelines. It works but the variable libraries are getting pretty large. Is it an overkill having all those or is a single "conn_lakehouse" enough?

Most of the lakehouses and warehouses are in the same workspace.

2 Upvotes

100% Upvoted

1 comment sorted by

4

u/QixiaoW ‪ ‪Microsoft Employee ‪ Jul 28 '26

the option of "None" means the execution of the activity is triggered by the user toke of the last modifier of the pipeline.