Azure data lake storage Gen2 error external location not found

Question

I used COPY INTO statement to copy csv file in ADLS Gen2 to Synapse table successfully with share access signature as credential. However, when I try to copy snappy.parquet file in the same storage account (different container) into a table in the same data warehouse, got error: "Not able to validate external location because The remote server returned an error: (404) Not Found.".
my code is:

CREATE EXTERNAL FILE FORMAT pqt
WITH (
FORMAT_TYPE = PARQUET
,DATA_COMPRESSION = 'org.apache.hadoop.io.compress.SnappyCodec'
);
COPY INTO [dbo].table
FROM 'https://mystorage.dfs.core.windows.net/../*.parquet'
WITH
(
FILE_FORMAT =pqt
,CREDENTIAL=(IDENTITY= 'Shared Access Signature', SECRET='sas token') )
Do you know how to solve this issue?

Thanks

Answer 1

Hi @leonfeng-5667,

Welcome to Microsoft Q&A Platform.

Thanks for posting the question. Yes, I reproduced and faced the same issue. Though it is Gen2 storage account, modifying this https://mystorage.dfs.core.windows.net/../*.parquet' to https://mystorage.blob.core.windows.net/../*.parquet' in COPY INTO statement is working for Parquet file.

I will work with Product team to understand the issue and will share more details with you.

Hope this helps.

Do click on "Accept Answer" and Upvote on the post that helps you, this can be beneficial to other community members.

Answer 2

files.autoSave

Answer 3

Dear @Anonymous ,

Thanks for this question, i understand your question well and this is great case to test the coverage of the product.
It seems to me, this is yet not launched in Azure space, however let's wait to hear from Microsoft internal product team.

Regards,
Girijesh