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 Data Warehouse connection, the advanced property values are retained. |
Source Type | Type of the source object. Select Single Object, Query, or Parameter. Default is Single Object. Note: You cannot read multiple Microsoft Fabric Data Warehouse objects, even though Multiple Objects appear in the list of source objects. |
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 Data Warehouse 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 from the data that the Secure Agent reads from the source. You can specify the following filter conditions:
Default is Not parameterized. |
Sort | Not applicable. |
Property | Description |
|---|---|
Schema Name Override | Overrides the schema name configured in the source object and uses the specified schema name to read data at runtime. |
Table Name Override | Overrides the table name configured in the source object and uses the specified table name to read data at runtime. |
SQL Override | The SQL statement to override the default query that is used to read data from the Microsoft Fabric Data Warehouse source. |
Pre SQL | The pre-SQL command to run on the Microsoft Fabric Data Warehouse source table before the Secure Agent reads the data. For example, if you want to update records in the database before you read the records from the table, specify a pre-SQL statement. |
Post SQL | The post-SQL command to run on the Microsoft Fabric Data Warehouse table after the Secure Agent completes the read operation. For example, if you want to delete some records after the latest records are loaded, specify a post-SQL statement. |
On Pre-Post SQL Error | Determines the behavior when a task that includes pre-SQL or post-SQL commands encounters errors. Select one of the following options:
|
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. |