CSV

The Comma-Separated Values (CSV) connector bridges the gap between raw text files and structured analytics. It allows users to query CSV files such as exports, logs, or reports using standard SQL without manual imports, data cleaning, or spreadsheet conversions.

At its core, the connector treats each line as a row and each comma-delimited value as a column. It automatically detects delimiters, headers, and data types, mapping flat files into a tabular schema that can be queried immediately. When you query a CSV file, the connector dynamically interprets its structure, transforming what’s often a simple exchange format 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 CSVs for exploration. Yet, for more complex files—where delimiters vary, headers are missing, or encoding differs—you can fine-tune behavior using a rich set of options that control how Metaform interprets the file’s structure and data types.