Fabric Warehouse BUG with COPY INTO when path contains a dash

[JohnMiner3]

Hi Team,

The code below does not find any files.  However, if I replace 'S&P-2013' with 'test' and move over a single test file, it works fine. I am pretty sure this is a bug since it is a allowable path name in ADLS.

Sincerely,  

John Miner

PS:  The new statement aligns with other vendors such as SNOWFLAKE.  I wish there was a way to place the secret into a vault and reference the vault instead of hard coding a SAS key that could be an attack vector. 

https://docs.snowflake.com/en/sql-reference/sql/copy-into-location

--

-- Load table - all years

--

COPY INTO [stocks].[snp500]

FROM

  "https://sa4adls2030.dfs.core.windows.net/raw/stocks/S&P-2013/*.CSV" ,

WITH

(

    FILE_TYPE = 'CSV',

    CREDENTIAL=(IDENTITY= 'Storage Account Key', SECRET='<skipped>'),

    FIELDQUOTE = '"',

    FIELDTERMINATOR=',',

    ROWTERMINATOR='0x0A',

    ENCODING = 'UTF8',

    FIRSTROW = 2

)