A FileName field is a string field that contains the source path of a file. The default precision for a FileName field is 255 characters for a flat file and 1024 characters for a complex file.
You cannot configure the FileName field. You can delete the FileName field if you do not want to read the data in the FileName field. You cannot create a folder name with more than 255 characters for a flat file and 1024 characters for a complex file.
FileName is a reserved keyword. Avoid using FileName as the column name in the source data. The name is case sensitive.
The FileName field is applicable to the following file formats:
•Flat file
•Avro
•Parquet
•ORC
Reading source objects path
When you import source objects, the Secure Agent appends a FileName field to the imported source object. The FileName field stores the absolute path of the source file from which the Secure Agent reads the data at run time.
For example, a directory contains a number of files and each file contains multiple records that you want to read. You select the directory as source type in the Microsoft Azure Data Lake Storage Gen2 source advanced properties. When you run the mapping, the Secure Agent reads each record and stores the absolute path of the respective source file in the FileName field.