Declarative Pipeline Failure for Autoloader

iskidet · ‎10-01-2025

Hello Folks,

After moving my working serverless Auto Loader notebook to a declarative (DLT) pipeline, I’m getting an AccessDenied error. What could be causing this?”

here is the DLT json and error message in the DLT

I googled around got saw some hint that DLT is trying to write to some staging temporary without, permission not which other permission, I should be adding.

@MohanaBasak

Thank you all.

Samson

nayan_wylde · ‎10-01-2025

Seems to me like the SPN or individual running the DLT pipeline need to have access on the external location and the main catalog.

GRANT ALL PRIVILEGES ON CATALOG <catalog_name> TO `<external_account_identifier>`;

Advika_ · ‎10-08-2025

Hello @iskidet!

Were you able to resolve the AccessDenied issue? If the above suggestion helped, or if you found another solution, it would be great if you could mark it as the accepted solution or share your approach with the community.