Add Timezone Configuration to CSV Data Format Parser

[haidlir]

Feature Request

Proposal:

Add a timezone configuration parameter to the CSV data format.

Current behavior:

Currently, any timestamp without timezone within the csv value will treated as UTC.

telegraf/plugins/parsers/csv/parser.go

Line 245 in 1e7f714

metricTime, err := internal.ParseTimestamp(timestampFormat, recordFields[timestampColumn], "UTC")

Desired behavior:

There is a way to set the timezone. Otherwise, it will be treated as UTC.

Use case:

There is a possibility that the csv file that we want to parse, containing timestamp column without any timezone information attached to it.

The expected format should be

• "2006-01-02T15:04:05Z07:00" or
• "Mon, 02 Jan 2006 15:04:05 MST".

Instead, we get

• "2020-06-02 21:05:00" in non-UTC timezone

In this case there is no possibility to ask the source to add the timezone information.

[haidlir]

PR #7619