cannot run t-sql notebook in pipeline

suggest to file a support ticket on this. thanks 

Hi slachmuyldera 

Welcome to the Microsoft Fabric Forum,

The error you are encountering, MwcTokenValidationException (HTTP 401), usually indicates a token validation issue related to authentication or authorization.

When a notebook is triggered through a pipeline in Microsoft Fabric, it uses a system-assigned managed identity or a service principal for authentication. If this identity or principal lacks the necessary permissions on the Datamart or Warehouse, the authentication will fail, even if the notebook runs successfully when executed manually.

Verify the permissions such as the service principal or user account running the pipeline has the appropriate read and write permissions to access the data warehouse.

Additionally, upgrading to the latest stable runtime version can sometimes resolve execution delays or metadata commit inconsistencies.

There is a known issue with the Distributed Query Processor (DQP) on the Microsoft side that could contribute to this behavior.

For further reference, a similar issue has been discussed in the following thread:

Solved: Unable to access Data Warehouse: MwcTokenValidatio... - Microsoft Fabric Community

If this information helps resolve your issue, kindly consider marking this response as the Accepted Solution, as it may assist other community members facing similar challenges.

Thank you for being part of the Microsoft Fabric Community.