Identifies a file to read when aggregating multiple files into a single table, to specify the schema of the aggregated table.

Data Type

string

Default Value

""

Remarks

Identifies a file to read when aggregating multiple files into a single table, to specify the schema of the aggregated table.

The path that you specify is resolved as follows:

• Relative path: resolved relative to the directory of the connection URI (the folder being aggregated).
• Absolute local path: a local path that starts with /, \, or a drive letter followed by a separator (for example, C:\ or C:/), optionally prefixed with file://, is always allowed, even when the connection points to cloud storage. In this case, the schema is read from the local file system while the data is read from the configured storage. Drive-relative values such as C: or C:dev are not treated as absolute paths.
• Absolute URI with a scheme: an absolute URI that includes a scheme (for example, s3://, gs://, or azureblob://) must point to the same storage as the connection. If its scheme does not match the connection's storage type, the connection fails with a configuration error.