Data Ingestion and Replication
- Data Ingestion and Replication
- All Products
ASK INFAPreview
Please log in to access Bolo.
ASK INFAPreview
Advance Source Property
| Description
|
|---|---|
File Pickup
| The file ingestion task supports the following file pickup methods:
|
Source Directory
| Microsoft Azure Data Lake Storage Gen2 folder path from where files are transferred. The default value is the container path specified in the connection.
You can enter a relative path to the source file system. To enter a relative path, start the path with a period, followed by a slash (./). The path is relative to the source directory specified in the connection.
|
Add Parameters
| Create an expression to add it as a
Source Directory parameter. For more information, see
Add Parameters.
|
Include files from sub-folders
| This applies when
File Pickup is
By Pattern . Transfer files from sub-folders present in the folder path.
|
File Pattern
| This applies when
File Pickup is
By Pattern . File name pattern used to select the files to transfer. You can use a regular expression or wildcard characters.
The following wildcard characters are allowed:
For example, you can specify the following regular expression:
([a-zA-Z0-9\s_\\.\-\(\):])+(.doc|.docx|.pdf)$
|
File Date
| This applies when
File Pickup is
By Pattern . A date and time expression for filtering the files to transfer.
Select one of the following options:
For example, if you schedule the
file ingestion task to run weekly and want to filter for the files that were modified in the previous week, set
Days before today to 7. The task will pick up any file with a date between 7 days ago and the date on which it runs.
|
Time Zone
| This applies when
File Pickup is
By Pattern . If you selected a
File Date option, enter the time zone of the location where the files are located.
|
File Size
| This applies when
File Pickup is
By Pattern . Filters the files to transfer based on file size. Enter the file size, select the file size unit, and filter options.
Select one of the following filter options:
|
The file path containing the list of files
| This applies when
File Pickup is
By File List . Select this option to provide the path that contains the list of files to pick up and enter the file path.
|
File list
| This applies when
File Pickup is
By File List . Select this option to provide the list of files to pick up and enter a comma-separated list of file names.
|
Skip duplicate files
| Do not transfer duplicate files. If files with the same name and creation date were transferred by the same
file ingestion task, the task does not transfer them again, and the files are marked as duplicate in the job log. If this option is not selected the task transfers all files.
|
Check file stability
| Indicates whether to verify that a file is stable before a file ingestion task attempts to pick it. The task skips unstable files it detects in the current run.
|
Stability check interval
| This applies when you enable the
Check file stability option. Time in seconds that a file ingestion task waits to check the file stability.
For example, if the stability time is 15 seconds, the file ingestion task detects all the files in the source folder that match the defined file pattern, it waits for 15 seconds, and then it processes only the stable files.
The interval ranges between 10 seconds to 300 seconds. Default is 10 seconds.
|
Batch Size
| The number of files a
file ingestion task can transfer in a batch.
Default is 5.
The maximum batch size varies, based on the following conditions:
If you transfer files from Microsoft Azure Data Lake Storage Gen2 to Azure SQL Data Warehouse, the task transfers files with no intermediate staging.
|
Block Size (Bytes)
| Divides a large file into smaller specified block size. When you read a large file, divide the file into smaller parts and configure concurrent connections to spawn the required number of threads to process data in parallel.
Default is 8388608 bytes (8 MB).
|
After File Pickup
| Determines what to do with source files after the files transfer. The following options are available:
|
