describe_file
Get column names, types, and row count for data files from local paths, globs, URLs, or S3. Supports CSV, Parquet, JSON, Excel, and compressed formats.
Instructions
Return the column names and types of a data file, plus its row count.
Works for any path DuckDB can read -- csv, parquet, json/ndjson, xlsx, compressed variants, globs matching many files, http(s) URLs and s3 URIs.
Args: path: File path, glob or URL, e.g. 'data/sales_*.parquet'. include_row_count: Set False to skip counting rows on very large inputs.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | Yes | ||
| include_row_count | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |