Microsoft Azure Data Lake Storage Gen2 Connector

Back Next

Rules and guidelines for wildcard characters

Consider the following rules and guidelines when you use wildcard characters:

Mappings: You cannot use wildcard characters when you read from partition columns.
When you read a complex file in a mapping, do not use a tilde (
~
) in the sub-directory name or file name.
When you use wildcard characters in directory override, the Secure Agent reads data from the folders as well as the files that match the name pattern.
Mappings in advanced mode: When you read a flat file or complex file and enable wildcard characters, ensure that the path specified in the directory override or file name override matches the file path in the source.
When you use wildcard characters, ensure that the file name does not start with a special character.
When you read a flat file, do not use the following special characters in the directory name or sub-directory name in the directory override:

[] {} " ' + ^ % * ? space