TSV

The Tab-Separated Values (TSV) connector bridges the gap between plain text exports and structured analytics. It allows users to query TSV files such as logs, data extracts, or reports using standard SQL without manual cleanup, copy-pasting, or format conversions.

At its core, the connector treats each line as a row and each tab-delimited value as a column. It automatically detects headers, infers data types, and maps fields into a tabular schema that can be queried immediately. When you query a TSV file, the connector dynamically interprets its structure, transforming what’s often a raw data dump into information 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 TSVs for exploration. Yet, for more complex files where tabs appear within quoted text or headers are inconsistent, you can fine-tune behavior using a rich set of options that control how Metaform interprets the file’s structure and typing.