Declarative Pipeline Failure for Autoloader

[iskidet]

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]

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_]

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.