Property | Description |
|---|---|
Connection | Name of the active Google Sheets source connection. |
Source Type | Type of the Google Sheets source objects available. You can read data from a single Google Sheets source object or parameterize the object. |
Object | Name of the Google Sheets source object based on the source type selected. |
Filter | Configure a simple filter or an advanced filter to remove rows at the source. You can improve efficiency by filtering early in the data flow. A simple filter includes a field name, operator, and value. Use an advanced filter to define a more complex filter condition, which can include multiple conditions using the AND or OR logical operators. |
Property | Description |
|---|---|
Terse | The Secure Agent logs initialization information, error messages, and notification of rejected data. |
Normal | The Secure Agent logs initialization and status information, errors encountered, and skipped rows due to transformation row errors. Summarizes session results, but not at the level of individual rows. |
Verbose Initialization | In addition to normal tracing, the Secure Agent logs additional initialization details, names of index and data files used, and detailed transformation statistics. |
Verbose Data | In addition to verbose initialization tracing, the Secure Agent logs each row that passes into the mapping. Also notes where the Secure Agent truncates string data to fit the precision of a column and provides detailed transformation statistics. When you configure the tracing level to verbose data, the Secure Agent writes row data for all rows in a block when it processes a transformation. |