Blob Storage Issue

Question

Hello Team,

I am transferring data from Blob storage(Source) to Snowflake tables(Target).In Blob storage I have multiple files :

But while creating the Linked service in SAS Url. I mentioned only the Blob storage path.I am getting below error :

SAS URL :https://STORAGRACCOUNTNAME.blob.core.windows.net/vine .

But when i mentioned the SAS URL as :https://STORAGRACCOUNTNAME.blob.core.windows.net/vine/details_2018Q1.csv.it is working fine.

My concerned is there are total 4 files .While loading each file whether i need to change the SAS URL .

Source : Azure Blob Storage

Target :Snowflake DB(It's in AWS)

I am transferring files from source to Target.As snowflake is in AWS I am getting error :

Regards
Rk

Answer 1

Hi @Rohit Kulkarni ,

Thanks for using Microsoft Q&A !!
Unfortunately, you cannot use Snowflake as a Sink if snowflake is on AWS. Currently, it supports writing to snowflake on Azure only. Please refer to the documentation.

Yes, regarding your SAS token, that is expected as you need SAS token for any specific resource to create a linked service against that resource.
Please let me know if you have any other questions.

Thanks
Saurabh