Share via

Unable to load the data into snowflake from Azure blob storage through ADF pipeline

Anonymous
2023-06-30T17:23:12.08+00:00

ErrorCode=SnowflakeFailToAccess,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Snowflake fails to access remote file. Please make sure you grant proper access permission to Snowflake in Azure Blob storage when using shared access signature. To learn more about this, see https://docs.snowflake.com/en/user-guide/data-load-azure-config.html#option-2-generating-a-sas-token.,Source=Microsoft.DataTransfer.Common,''Type=System.Data.Odbc.OdbcException,Message=ERROR [22000] Failure using stage area. Cause: [This request is not authorized to perform this operation. (Status Code: 403; Error Code: AuthorizationFailure)],Source=SnowflakeODBC_sb64.dll,'

Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
3,031 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,113 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaikMaheer-MSFT 38,501 Reputation points Microsoft Employee
    2023-07-04T17:05:44.3866667+00:00

    Hi SOMISETTY, SUNIL,

    Thank you for posting query in Microsoft Q&A Platform.

    The error message indicates that Snowflake is unable to access the remote file, and suggests that you may need to grant proper access permission to Snowflake in Azure Blob Storage when using shared access signature.

    Could you please confirm while generating SAS token you selected required permissions ? If not, please try that and share updates.

    If not helps, then please share more details on SAS generation what you selected there and at what folder level you generated SAS?

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.