Hi @Retired_mod, hope you are well.

This is still not working for me.

For example:

  • Full path works fine: 
    • abfss://<container>@<storage_account>.dfs.core.windows.net/automation/<subfolder1>/<subfolder2>/<subfolder3>/part_0_0001.csv
  • But as soon as a use wildcard, any of below options fail:
    • abfss://<container>@<storage_account>.dfs.core.windows.net/automation/<subfolder1>/<subfolder2>/<subfolder3>/*.csv  (on File name)
    • abfss://<container>@<storage_account>.dfs.core.windows.net/automation/<subfolder1>/<subfolder2>/*/part_00001.csv (on Subfolder)
      ERROR:
      Failure to initialize configuration for storage account <storage_account>.dfs.core.windows.net: Invalid configuration value detected for fs.azure.account.key 
 
My table settings are:
USING csv
OPTIONS ( 'DATEFORMAT' = 'MM/dd/yyyy''ESCAPE' = '"''HEADER' = 'true')
 
Any suggestions?
Emiliano

full_path.png

 

wildcard.png