AggregateFiles
When set to true, the provider will aggregate all the files located in the URI directory that have the same schema into a single table called AggregatedFiles .
Data Type
bool
Default Value
false
Remarks
By default, the first file in the folder is used to define the schema, however MetadataDiscoveryURI can be specified to use a different file instead.
Take for example the following CSV contents.
File 1
ItemID,Name,NumInStock 1,Peanuts - Salted,76 2,Peanuts - Unsalted,43 3,Raisins,26
File 2
ItemID,Name,NumInStock 4,Pretzels - Original,55 5,Pretzels - Chocolate,35 6,Toffee,44
The resulting aggregate table is shown below. Note that only the columns present in the defined schema are used in the aggregate.
AggregateFiles
ItemID,Name,NumInStock 1,Peanuts - Salted,76 2,Peanuts - Unsalted,43 3,Raisins,26 4,Pretzels - Original,55 5,Pretzels - Chocolate,35 6,Toffee,44