Specifies whether the provider aggregates all files with the same schema in the specified folder into a single table called AggregatedFiles .

Data Type

bool

Default Value

false

Remarks

When this property is set to true, the connector combines all files in the specified folder that share a common schema. The first file defines the schema unless MetadataDiscoveryURI is specified to use another file.

For example, the following two CSV files share the same column structure:

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 connector aggregates the files into a single result set. Only the columns present in the defined schema are included in the aggregate.

AggregatedFiles

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

This property is useful for unifying data from multiple files with identical formats into a single result set.