Blob to Snowflake Data Ingestion using Azure Data factory
I am loading data from azure blob to snowflake using for each in Data factory.
Most of the copy loads are successful, sometimes I am facing the issue as below and sometimes its going smooth.
ErrorCode=UserErrorOdbcOperationFailed,’Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ERROR [HY000] [Microsoft][Snowflake] (4)
REST request for URL *** failed: HTTP error (http error) – code=503.
,Source=Microsoft.DataTransfer.Runtime.GenericOdbcConnectors,”Type=System.Data.Odbc.OdbcException,Message=ERROR [HY000] [Microsoft][Snowflake] (4)
REST request for URL *** failed: HTTP error (http error) – code=503.
,Source=SnowflakeODBC_sb64.dll,’
I want to know what is the problem here.. Test connection of linked service looks good.
I have all permissions too. Just want to know what I am missing here.
enabled staging and tried increased with DIU’s..
Read more here: Source link
