Share via

Sql error number: 15883. Error Message: Access check for 'CREATE/WRITE' operation against

DC-q489h2 126 Reputation points
2022-12-07T23:08:23.263+00:00

I am receiving the following error and cannot find any documentation on how to fix. I am trying to run stored procedure in Synapse SQL serverless. I have other activities in my pipeline that can successfully access data in the same database.

Sql error number: 15883. Error Message: Access check for 'CREATE/WRITE' operation against [storage file path redacted] failed.

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,373 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. DC-q489h2 126 Reputation points
    2022-12-14T14:19:12.53+00:00

    Hi @Bhargava-MSFT thank you for your response. The issue turned out to be the wrong storage container was provided in the soruce path and was not initially apparent.

    1 person found this answer helpful.
  2. Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator
    2022-12-08T20:02:09.877+00:00

    Hello @DC-q489h2 ,

    Welcome to the MS Q&A platform.

    Please correct me if my understanding is wrong. You are trying to create an external table and getting this error.

    Error "Access check for 'CREATE/WRITE' operation against [storage file path redacted] failed." generally means access credentials are not set up properly, or the input file is not accessible due to external reasons.

    Can you please confirm if this is a transient issue or if this issue happens every time?

    If you see this error every time, please check the access credentials and the input file path.

    I hope this helps. Please let me know if you have any further questions.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.