When I first attempted to run the data transfer, I got the error "The remote server returned an error: (403) Forbidden.,Source=Microsoft.WindowsAzure.Storage,StorageExtendedMessage=Server failed to authenticate the request. Make sure the value of Authorization header is formed correctly including the signature." I realized that this error was caused by me enabling staging. However, the only reason I enabled staging in the first place is because it is necessary for the first row to be registered as a header. When I turn off the setting to read the row as the first header, the mapping gets messed up.
So far, I ve tried just leaving on the read the first row as a header. When I do this, though, I get the error message Direct copying data to Snowflake is only supported when source dataset "First row as header" is set as false or "Row delimiter" is , please enable staging or fix First row as header. No matter what the row delimiter is set to, the only fix to this issue is enabling staging. However, one user on stackoverflow said enabling staging causes the 403 forbidden error, which turned out to be true. If anyone has any help for this problem please let me know. At this point I cant figure out any fixes so any help would be appreciated. Thanks!