CREATE EXTERNAL TABLE test_table ( bd datetime2(7) NULL, name1 nvarchar(max) NULL, last nvarchar(max) NULL ) WITH ( LOCATION = 'abfss://hhrr@xxxxx.dfs.core.windows.net/bronze/ext/test_table', DATA_SOURCE = datasource_bronzedb001, FILE_FORMAT=DELTA );
select * from test_table
get the below error message
Started executing query at Line 3 Content of directory on path 'https://xxxxxx.dfs.core.windows.net/hhrr/bronze/db/abfss://hhrr@xxxxx.dfs.core.windows.net/bronze/ext/test_table/_delta_log/.' cannot be listed.
