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 )
... View more