Property | Description |
|---|---|
Connection | Name of the source connection. Select an existing connection, create a new connection, or define parameter values for the source connection property. If you want to overwrite the parameter at runtime, select the Allow parameter to be overridden at run time option when you create a parameter. When the task runs, the agent uses the parameters from the file that you specify in the task advanced session properties. Ensure that the parameter file is in the correct format. Specify the parameter file directory and name in the advanced session properties. When you switch between a non-parameterized and a parameterized Microsoft Fabric Lakehouse connection, the advanced property values are retained. |
Source Type | Type of the source object. Select Single Object, Query, or Parameter. Default is Single Object. |
Parameter | A parameter file where you define values that you want to update without having to edit the task. The Parameter property appears only if you select the source type as Parameter. Select an existing parameter for the source object or click New Parameter to define a new parameter for the source object. If you want to overwrite the parameter at runtime, select the Allow parameter to be overridden at run time option when you create a parameter. When the task runs, the agent uses the parameters from the file that you specify in the task advanced session properties. Ensure that the parameter file is in the correct format. |
Object | Name of the Microsoft Fabric Lakehouse source object. Select the source object for a single source. You can also select an existing object from the list. Ensure that the table headers of the source object do not contain special characters. |
Property | Description |
|---|---|
Filter | Filters record based on the filter condition in a read operation. Click Configure to add conditions to filter records and reduce the number of rows that the Secure Agent reads from the source. Select one of the following filter conditions from the list:
Default is Not parameterized. |
Sort | Not applicable. |
Property | Description |
|---|---|
Table Name Override | Overrides the table name configured in the source object and uses the specified table name to read data at runtime. |
Tracing Level | Sets the amount of detail that appears in the log file. Select one of the following options from the list:
Default is Normal. |