Pipelines deployments failing with "User does not have access to the connection used in the Pipeline"

[b-joubert]

What is the question?

Hi,
Firstly, thanks for the nice work on this ;)
I have pipelines deployments failing with "User does not have access to the connection used in the Pipeline. Please verify the user's permissions."
My pipeline contains:

• connections configured with library variables
• connections to Fabric SQL DB
  Could this explain the error ?
  I could remove library variables and replace information when deploying with parameter.yml file

PS:
I had to add this in the parameter.yml so it passes structure validation ;)

find_replace:
    # Dummy for valid parameter file structure
    - find_value: "xxx"
      replace_value:
        TST: "xxx"
        PROD: "xxx"
      item_type: "Notebook"
      item_name: ["Dummy"]

key_value_replace:
...

Additional context

No response

[b-joubert]

FYI, I tried to deploy after removing Lookup activities using connections to Fabric SQL DB and deployment went fine
So issue seems related to connections to Fabric SQL DB

[b-joubert]

I think I understood :)
So I edited my pipelines and recreated the connection :

After this, I updated the permissions of this connection and deployments are now working

However, this connection uses Oauth authentication with my credentials and I'd prefer if it was possible to use either SPN or workspace MSI :/

Any idea if this is planned somehow ?

[pavanyarraboyina]

Since I am using a client ID and client secret for deployment through CI/CD, should the same client ID also have access to the connection being used?

Also, for the connections used in the data pipeline, are there any specific permissions required?

Could you please help clarify my query?

[JacobKnightley]

pavanyarraboyina yes that is correct, your deploying identity needs access to the connections to be successful. Read permissions only.