PSV

The Pipe-Separated Values (PSV) connector bridges the gap between system-generated exports and structured analytics. It allows users to query PSV files such as data feeds, application logs, or reporting outputs using standard SQL without writing parsers, splitting text, or reformatting data by hand.

At its core, the connector treats each line as a row and each pipe-delimited value as a column. It automatically detects headers, infers data types, and maps fields into a tabular schema ready for immediate querying. When you query a PSV file, the connector dynamically interprets its structure, transforming what’s often a machine-oriented export into data your query engine can reason about.

This connector is designed for both simplicity and precision. With just a few lines of configuration, you can open up entire directories of PSV files for exploration. Yet, for more complex files where delimiters appear in text fields or schema consistency varies, you can fine-tune behavior using a rich set of options that control how Metaform interprets the file’s layout and data types.