Hi All
I am trying to create a single external tables in Azure Synapse. Files location is Azure blob, format CSV.
If I connect the external table with file location then it works perfectly but I connect it just folder locations then instead of showing me data from multiple files it returns empty table. There is no error but it is not returning data.
CREATE EXTERNAL TABLE [stage].[TableName]
(
[Columns] Datatype
)
WITH (LOCATION = '/Legacy/WEBXL',
DATA_SOURCE = [BlobStorage],
FILE_FORMAT = [CsvFormatPipeSeperated]
)
). This can be beneficial to other community members. Thank you.

