Some methods in notebooks do not work when executed from Data Pipelines deployed via SPN

[milosdatabob]

Library Version

0.1.12

What is the problem?

Hi,

This seems to be related to this issue here, but I also identified that this issue is present when using a couple of more methods:

1. synapsesql() (first 2 screenshots below)
2. notebookutils.lakehouse.get()
3. notebookutils.runtime.context.get("currentWorkspaceName") (as already noted in the linked issue)

Does anyone has any additional insights or potential resolutions to this?

I only provided the screenshots for the bullet 1, but in general it is the same pattern:

User's isolated DEV workspace/environment:

1. the code works when notebook is executed via Data Pipeline (if user saved the data pipeline)
2. the code works when executed directly from the notebook

Test/Prod deployment environments:

1. the code works in the next environment when deployed using SPN and when executed directly from the Notebook
2. the code does not work in the next environment when deployed using SPN and when Notebook executed from Data Pipeline

Is there an ideal solution?

No response

Additional context, screenshots, logs, error output, etc

No response

[umar-lab3nz]

Hi @JacobKnightley are there any updates on this as its linked to issue #172 ?

[JacobKnightley]

Hi there! This isn't a fabric-CICD issue but instead a product issue. I would recommend reaching out to support. You should be able to reproduce this with a direct api call. Let me know if you need assistance with a simple repro.