What are the props.conf standard settings for DB Connect inputs?

[rsannala]

Hello Experts,

We have splunk DB connect inputs configured to fetch logs from DB tables based on SQL queries.

In general for unstructured data we will apply below standard props.conf settings as a best practice.

TIME_FORMAT
MAX_TIMESTAMP_LOOKAHEAD
SHOULD_LINEMERGE

LINE_BREAKER
TRUNCATE

TIME_PREFIX

do we need to configure above settings for DB connect logs as well ? if yes what will be the suggested values.

Please help me to understand this.

[isoutamo · Accepted solution]

Usually you set a needed parameters when you are defining DB inputs (with GUI). So no needs to add those separately.

r. Ismo

[rsannala]

Thank you for confirming