expanso-normalize-timestamps

What problem does it solve?

This Skill addresses the challenge of inconsistent timestamp formats and timezones in data by normalizing them all to a standard UTC format.

Core Features & Use Cases

• Format Detection: Automatically identifies various timestamp formats (ISO 8601, Unix epoch, custom).
• Timezone Conversion: Converts detected timestamps to Coordinated Universal Time (UTC).
• Metadata Enrichment: Adds useful time-based metadata like year, month, day, hour, day of week, and quarter.
• Quality Scoring: Provides a score indicating the success of parsing and conversion.
• Use Case: Ingesting event data from multiple sources with different timestamp conventions and ensuring all events are logged and analyzed with a consistent, comparable UTC timestamp.

Quick Start

Run the normalize-timestamps skill pipeline using the provided pipeline.yaml configuration.