Cloud Data Integration Connectors All Products
|Connection||Name of the source connection.|
|Source Type||Type of the source object. Select Single Object, Multiple Objects, Query, or Parameter.
When you use a custom SQL query to import Snowflake tables, the Secure Agent fetches the metadata using separate metadata calls.
|Object||The source object for the task. Select the source object for a single source. When you select the multiple source option, you can add source objects and configure relationship between them.|
|Filter||Filters records based on the filter condition. Configure a simple filter.|
|Sort|| Sorts records based on the conditions you specify. You can specify the following sort conditions:
|Database||Overrides the database specified in the connection.|
|Schema||Overrides the schema specified in the connection.|
|Warehouse||Overrides the Snowflake warehouse name specified in the connection.|
|Role||Overrides the Snowflake role assigned to user, specified in the connection.|
|Pre SQL||SQL statement that is executed prior to start of a read operation. 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||SQL statement that is executed after completion of a read operation. For example, if you want to delete some records after the latest records load, specify a Post-SQL statement.|
|Table Name||Overrides the table name of the imported Snowflake source table.|
|SQL Override||The SQL statement to override the default query used to read data from the Snowflake source.|
|Tracing Level||Determines the amount of detail that appears in the log file. You can select Terse, Normal, Verbose Initialization, or Verbose Data. Default value is Normal.|