Advanced settings

Auto Debug = boolean

Choose whether to automatically log debug information about your load. These logs can be found in the task history and should be included in support requests concerning the component. This property is set to No by default. Turning this on will override any debugging Connection Options you may have set.

Debug Level = drop-down

The level of detail you want to include in your debug logs. Select a level between 1 and 4:

1. Will log the query, the number of rows returned by it, the start of execution, the time taken, and any errors.
2. Will log everything included in Level 1, plus cache queries and additional information about the request, if applicable.
3. Will log everything included in Levels 1 and 2, and additionally log the body of the request and the response. This is the default logging level when debug logging is activated.
4. Will log everything included in Levels 1, 2, and 3, and additionally log transport-level communication with the data source. This includes SSL negotiation.

Levels above 1 can log huge amounts of data and result in slower query execution.

Parse 'Null' & Empty Strings as NULL = boolean

Converts common strings that represent null into a null value. This is case-sensitive and works with the following strings: "", "NULL", "NUL", "Null", "null". The default is No.

Note

Currently, this property is only applicable when using Snowflake as your destination.

Trim String Columns = boolean

When Yes, remove leading and trailing characters from a string column. The default is No.

Fetch Size = integer (optional)

Specify the batch size of rows to fetch at a time, for example, 500. When left blank, the chosen database's driver default fetch size is used.